NEW! FREE 30 Minutes MS Excel - Working with Dates Course  Watch now 

Power BITutorials

Learn How to Merge Columns in Power Query

1 Mins read

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

 

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

 

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:

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…