2022 updates MS Excel - Data Cleaning Course Enroll now  
Power BITutorials

4 Easy Steps to Concatenate 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.

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

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

Data Analytics Tricks in Power BI – Guidebook

You too can analyze data like a Data Scientist. No coding needed. No statistics needed.

Analyze & Visualize data using Power BI. (23 tricks in one book)

Related posts
AlteryxTutorials

Alteryx Hotkeys - Alteryx Keyboard Shortcuts

2 Mins read
Top 50+ Alteryx Shortcuts for Windows. Alteryx is popularly known as a Self-Service Analytics tool. Business users can build their data workflows…
AlteryxTutorials

Step By Step Guide to Learn Alteryx

6 Mins read
Alteryx Learning Path: The growth in technology has resulted in growth in understanding. In today’s world, humans – fellow businessmen know the…
Excel VBA CodeTutorials

VBA Code to Clean the Date Format

1 Mins read
When it is useful? Most of the time the most annoying problem is when the data is taken from ERP or other…