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.
Step 2: Merge Columns
To merge columns in Power Query, click on-
Add Column > Merge 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.
Step 4: Close & Apply
After merging columns in Power Query successfully, click on Close & Apply button to save the changes.
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)