{"id":176499,"date":"2024-01-16T16:33:16","date_gmt":"2024-01-16T15:33:16","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=176499"},"modified":"2024-01-16T18:14:53","modified_gmt":"2024-01-16T17:14:53","slug":"contatenate-function-in-power-query-full-tutorial","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial","title":{"rendered":"CONCATENATE function in Power Query: Full tutorial"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"176499\" class=\"elementor elementor-176499\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-853e39f e-flex e-con-boxed e-con\" data-id=\"853e39f\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-003bfc3 elementor-widget elementor-widget-heading\" data-id=\"003bfc3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">While Power Query offers a multitude of functions, some are not directly accessible from the ribbon. This is precisely the case with the CONCATENATE function, which allows you to merge several columns. So how do you use CONCATENATE in Power Query? That's what we're going to look at in this article.<span style=\"color: var( --e-global-color-primary ); text-align: var(--text-align);\"><\/span><br><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2b725a2 e-flex e-con-boxed e-con\" data-id=\"2b725a2\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b9d0576 elementor-widget elementor-widget-heading\" data-id=\"b9d0576\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">What is the CONCATENATE function in Power Query?<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6c000f7 elementor-widget elementor-widget-text-editor\" data-id=\"6c000f7\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p>The CONCATENATE function in <a href=\"https:\/\/datascientest.com\/en\/power-query-what-is-it-whats-it-for\">Power Query<\/a> lets you merge text and\/or numeric columns. One of the most common examples is last name and first name.<\/p><p>Whatever columns you wish to merge, here&#8217;s how to do it:<\/p><ul><li>load the data into the query editor by going to the &#8220;Data&#8221; tab, then select &#8220;from table or range&#8221; ;<\/li><li>check the columns you wish to merge: <br \/>click on &#8220;Add Column&#8221;, then on &#8220;Customize Columns&#8221; ;<\/li><li>specify the name of the new column; <br \/>in the &#8220;Column customization formula&#8221; section, you can write in<a href=\"https:\/\/datascientest.com\/en\/power-query-m-language-avoid-these-mistakes\"> M language.<\/a><\/li><li>In other words, use the CONCATENATE formula in Power Query. This takes the form =[column 1]&amp;&#8221;&#8221;&amp;[column 2] ; <br \/>click on &#8220;OK&#8221;, &#8220;Close&#8221; and &#8220;Apply&#8221;.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5c35871 elementor-widget elementor-widget-text-editor\" data-id=\"5c35871\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Your two columns have merged.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-658dd8a elementor-widget__width-initial elementor-widget elementor-widget-code-highlight\" data-id=\"658dd8a\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-okaidia  \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-markup \">\n\t\t\t\t<code readonly=\"true\" class=\"language-markup\">\n\t\t\t\t\t<xmp>let  \r\n   Variablename = expression,  \r\n   #\"Variable name\" = expression2  \r\nin   \r\n   Variablename<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-dc64add e-flex e-con-boxed e-con\" data-id=\"dc64add\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2b69c1e elementor-widget elementor-widget-heading\" data-id=\"2b69c1e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">How do I use the \"Merge columns\" in Power Query function ? <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3311b2b elementor-widget elementor-widget-text-editor\" data-id=\"3311b2b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>If you don&#8217;t want to use a formula, you can also merge columns using a specific function.<\/p><p>Here again, the procedure is very simple:<\/p><ul><li>load the data into the query editor by going to the &#8220;Data&#8221; tab, then select &#8220;from table or range&#8221; ;<\/li><li>select the columns you wish to merge; <br \/>click on &#8220;Add Column&#8221;, then on &#8220;Merge Columns&#8221;.<\/li><li>select the separator from the drop-down list.<\/li><li>You can choose a space, a dash, a comma&#8230; between the two data sets; <br \/>specify the name of the new column; <br \/>click on &#8220;OK&#8221;.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-86aae33 elementor-widget elementor-widget-text-editor\" data-id=\"86aae33\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>A new column then appears in your query editor.<\/p><p><strong>Good to know:<\/strong> The<strong> CONCATENATE function<\/strong> in <a href=\"https:\/\/datascientest.com\/en\/power-bi-direct-query-all-you-need-to-know-about-this-data-query-method\">Power Query<\/a> does not overwrite existing columns, which are therefore still present in your table. If, for example, it&#8217;s the first and last name, you could have 3 columns with this information.<\/p><p>This can be a bit redundant. So if you want to remove them, you can always use the query editor&#8217;s transformation tools.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b7cd440 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"b7cd440\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Learn how to merge columns in Power Query<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c2f85ff e-flex e-con-boxed e-con\" data-id=\"c2f85ff\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-dd197ff elementor-widget elementor-widget-heading\" data-id=\"dd197ff\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">The \"Column from example\" function<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d0b21ee elementor-widget elementor-widget-text-editor\" data-id=\"d0b21ee\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>You can <strong>concatenate two columns in Power Query<\/strong> using the &#8220;Column from example&#8221; function.<\/p><p>The idea is to create a new column in an existing table by specifying a template. To do this, you have two options:<\/p><ul><li><strong>From all columns:<\/strong> Power Query identifies a template for all table columns.<\/li><li><strong>From a selection<\/strong>: Power Query identifies a template for selected columns only.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0c5d760 elementor-widget elementor-widget-image\" data-id=\"0c5d760\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/03\/colonne-a-partir-dexemples-1.jpg\" title=\"\" alt=\"\" loading=\"lazy\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bd0b54c elementor-widget elementor-widget-text-editor\" data-id=\"bd0b54c\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Whichever option you choose, the procedure is as follows:<\/p><ul><li>load the data into the query editor by going to the &#8220;Data&#8221; tab, then select &#8220;from table or range&#8221; ;<\/li><li>select the columns you wish to merge:<\/li><li>click on &#8220;Add Column&#8221;, then on &#8220;Column from example&#8221; ;<\/li><li>click on the drop-down list and select &#8220;From selection&#8221; ;<\/li><li>a &#8220;Merge&#8221; column appears. Enter the desired result here. If the first name is &#8220;Marie&#8221; and the last name &#8220;Dupond&#8221;, you can, for example, write &#8220;Marie Dupont&#8221;, &#8220;Marie.Dupond&#8221;, &#8220;Marie-Dupond&#8221;&#8230;<\/li><li>Depending on how you write it, you&#8217;ll see that the M language is automatically written at the top.<\/li><li>After several tests, select the option that suits you best; <br \/>once you&#8217;re satisfied with the Power Query preview, click &#8220;Ok&#8221;.<\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8067826 elementor-widget elementor-widget-text-editor\" data-id=\"8067826\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>This option allows you to quickly get a visual result for your columns.<\/p><p>\u00a0<\/p><p>\ud83d\udca1 Related articles:<\/p><table dir=\"ltr\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\" data-sheets-root=\"1\"><colgroup><col width=\"656\" \/><\/colgroup><tbody><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;DAX Power BI: all about the query programming language&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/dax-power-bi-all-about-the-query-programming-language\" target=\"_blank\" rel=\"noopener\">DAX Power BI: all about the query programming language<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI Direct Query: All you need to know about this data query method&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-direct-query-all-you-need-to-know-about-this-data-query-method\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-direct-query-all-you-need-to-know-about-this-data-query-method\" target=\"_blank\" rel=\"noopener\">Power BI Direct Query: All you need to know about this data query method<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI Desktop download and installation guide I DataScientest&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-desktop-download-and-installation-guide\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-desktop-download-and-installation-guide\" target=\"_blank\" rel=\"noopener\">Power BI Desktop download and installation guide I DataScientest<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI Time Intelligence: Everything you need to know about these DAX functions&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-time-intelligence-everything-you-need-to-know-about-these-dax-functions\" target=\"_blank\" rel=\"noopener\">Power BI Time Intelligence: Everything you need to know about these DAX functions<\/a><\/td><\/tr><tr><td data-sheets-value=\"{&quot;1&quot;:2,&quot;2&quot;:&quot;Power BI Report Builder: What is it? How do I use it?&quot;}\" data-sheets-hyperlink=\"https:\/\/datascientest.com\/en\/power-bi-report-builder-what-is-it-how-do-i-use-it\"><a class=\"in-cell-link\" href=\"https:\/\/datascientest.com\/en\/power-bi-report-builder-what-is-it-how-do-i-use-it\" target=\"_blank\" rel=\"noopener\">Power BI Report Builder: What is it? How do I use it?<\/a><\/td><\/tr><\/tbody><\/table>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-da39c20 e-flex e-con-boxed e-con\" data-id=\"da39c20\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2a98e9f elementor-widget elementor-widget-heading\" data-id=\"2a98e9f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Conclusion <\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a7d616b elementor-widget elementor-widget-text-editor\" data-id=\"a7d616b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Whichever method you use to implement the <strong>CONCATENATE function in Power Query,<\/strong> the result will be essentially the same. But if you&#8217;re not familiar with the manipulations described above, it will be difficult to merge cells.<\/p><p>And the same applies to many transformation functions.<\/p><p>In fact, <a href=\"https:\/\/datascientest.com\/en\/power-query-rank-top-tips-to-use-it\">Power Query offers you over 300 of them<\/a>, and if you want to discover them all, it&#8217;s best to learn how to use the tool. That&#8217;s why you should take one of our Datascientest training courses.<\/p><p>You&#8217;ll learn about <a href=\"https:\/\/datascientest.com\/en\/apache-kafka-the-real-time-data-processing-platform\">data processing<\/a>, analysis, prediction, modeling and more.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-79fc1de elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"79fc1de\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Discover Excel training <\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-db30b5b e-flex e-con-boxed e-con\" data-id=\"db30b5b\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7edf759 elementor-widget elementor-widget-html\" data-id=\"7edf759\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\n{\n  \"@context\": \"https:\/\/schema.org\",\n  \"@type\": \"FAQPage\",\n  \"mainEntity\": [{\n    \"@type\": \"Question\",\n    \"name\": \"What is the CONCATENATE function in Power Query?\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"The CONCATENATE function in Power Query can be used to merge text and\/or numeric columns. One of the most common examples is last name and first name.\"\n    }\n  },{\n    \"@type\": \"Question\",\n    \"name\": \"The \"Column from example\" function\",\n    \"acceptedAnswer\": {\n      \"@type\": \"Answer\",\n      \"text\": \"You can concatenate two columns from Power Query using the \"Column from example\" function. The idea is to create a new column in an existing table by specifying a model. To do this, you have two options: From all columns: Power Query identifies a template for all table columns. From a selection: Power Query identifies a template for selected columns only.\"\n    }\n  }]\n}\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>While Power Query offers a multitude of functions, some are not directly accessible from the ribbon. This is precisely the case with the CONCATENATE function, which allows you to merge several columns. So how do you use CONCATENATE in Power Query? That&#8217;s what we&#8217;re going to look at in this article. What is the CONCATENATE [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":176504,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2420],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>CONCATENATE function in Power Query: Full tutorial<\/title>\n<meta name=\"description\" content=\"When using the CONCATENATE function ins Power Query, in order to avoir all risks, you have to understand that...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CONCATENATE function in Power Query: Full tutorial\" \/>\n<meta property=\"og:description\" content=\"While Power Query offers a multitude of functions, some are not directly accessible from the ribbon. This is precisely the case with the CONCATENATE\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-16T15:33:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-16T17:14:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/01\/CONTATENATE-function.png\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"384\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"CONCATENATE function in Power Query: Full tutorial\",\"datePublished\":\"2024-01-16T15:33:16+00:00\",\"dateModified\":\"2024-01-16T17:14:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial\"},\"wordCount\":716,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Business Intelligence\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial\",\"url\":\"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial\",\"name\":\"CONCATENATE function in Power Query: Full tutorial\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-01-16T15:33:16+00:00\",\"dateModified\":\"2024-01-16T17:14:53+00:00\",\"description\":\"When using the CONCATENATE function ins Power Query, in order to avoir all risks, you have to understand that...\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"CONCATENATE function in Power Query: Full tutorial","description":"When using the CONCATENATE function ins Power Query, in order to avoir all risks, you have to understand that...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial","og_locale":"en_GB","og_type":"article","og_title":"CONCATENATE function in Power Query: Full tutorial","og_description":"While Power Query offers a multitude of functions, some are not directly accessible from the ribbon. This is precisely the case with the CONCATENATE","og_url":"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-01-16T15:33:16+00:00","article_modified_time":"2024-01-16T17:14:53+00:00","og_image":[{"width":768,"height":384,"url":"https:\/\/datascientest.com\/en\/files\/2024\/01\/CONTATENATE-function.png","type":"image\/png"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"CONCATENATE function in Power Query: Full tutorial","datePublished":"2024-01-16T15:33:16+00:00","dateModified":"2024-01-16T17:14:53+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial"},"wordCount":716,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Business Intelligence"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial","url":"https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial","name":"CONCATENATE function in Power Query: Full tutorial","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-01-16T15:33:16+00:00","dateModified":"2024-01-16T17:14:53+00:00","description":"When using the CONCATENATE function ins Power Query, in order to avoir all risks, you have to understand that...","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/contatenate-function-in-power-query-full-tutorial"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/176499"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=176499"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/176499\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/176504"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=176499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=176499"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=176499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}