Worlds best Ms Office Tutorial content. Find anything about Ms Office Tutorial on this site.
Merge Columns Power Query. I need to combine two text columns. The source data for the query was simple and had only a few columns.
Tutorial Extend Data Model Relationships Using Excel Power Pivot And Dax Excel Excel Power Data from www.pinterest.com
Ive tried it in the custom column with the Formuala but I get an error. After you click on Merge Columns option a Merge Columns window gets open. In the Power Query Editor window go to the Add Column tab and click on the Custom Column icon.
To concatenate two columns in Power Query you have to write a formula.
Power query - concatenate text columns. A merge queries operation joins two existing tables together based on matching values from one or multiple columns. To combine columns in Power Query we use the Custom column option. Each row in Table 2 will have 1 or more column data.
