Need Help? Chat with us

Learn How to Merge Columns in Power Query

Merging columns is also a feature of Power Query which is very useful for transforming data. You can use this feature easily by following below steps.

Merge Columns in Power Query

MICROSOFT POWER QUERY FOR BEGINNERS
• Course Certificate • Lifetime Access & Free Updates • Lifetime Support • Career Focused

 

Step 1: Select the Columns in Power Query for Merging

If you have a data table as shown below and you want to merge the two columns together then just select the columns in Power Query.

SELECT COLUMNS FOR MERGING

Step 2: Merge Columns

To merge columns in Power Query, click on-

Add Column  >  Merge Columns

MERGE SELECTED COLUMNS

Step 3: Add Separator to the Merged Column

After you click on Merge Columns option, a Merge Columns window gets open.

In this window, you have to add a separator in the Separator option from the dropdown list. Here, we have selected the Space option as the separator between two texts. Another option is to add a new column where you have to specify the column name as shown in below picture.

ADD SEPARATOR IN MERGE COLUMNS WINDOW

MICROSOFT POWER QUERY TRAINING
• 100+ Video Tutorials • 15 Case Studies • 2 eBooks • 10 Presentation Decks • 2 Webinar • 24*7 Dedicated Support

 

Step 4: Close & Apply

After merging columns in Power Query successfully, click on Close & Apply button to save the changes.

DATA TABLE AFTER MERGING COLUMNS

Looking for in-depth knowledge of Power Query? then check out our latest and highly demanded Power Query Course which helps in data cleaning and data transformation techniques. 

You can learn more: