Combining two data columns into one in Power Query

[pigsinblankets]

Good Afternoon,

I have two text columns that I'm looking to combine into one column - not merged together I want them pulled together by a unique ID which combines the two columns into one. 

Basically I have data pulling from two separate sources which is pulling in the same information (priority) and am looking to combine this priority column so I can filter by that priority for the combined data table with data from both systems - is there a simple way for combining two text columns in this way? 

Apologies brain a bit slow on a Monday! 

[pigsinblankets]

Thank you all for your responses @vanessafvg @v-yueyunzh-msft @Analystmate it's much appreciated I have got this working now using the unpivot columns method 🙂 

[Analystmate · Accepted solution]

@pigsinblankets 

Try this.

SS1.
(SS1) Select both columns> (SS2) Goto Tranform tab > Click on Unpivot Column > (SS.3) Remove the empty form value field. > SS 4 ( Result )

SS.2

SS.3

SS.4

[atrain204]

this worked like a charm for me too.  Thanks!

[v-yueyunzh-msft]

Hi , @pigsinblankets 

According to your description, you want to merge two Text columns to one in Power Query Editor.Right?

You can select your two column , and click "Merge Columns" in "Add Column":

Then you can add Separator to the Merged Column:

For more information, you can refer to :
4 Easy Steps to Concatenate Columns in Power Query (yodalearning.com)

If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[vanessafvg]

please provide data to support what you are saying. its much easier to provide a solution with an example of the data in text format.

1. provide sample data

2. example of expected solution

[pigsinblankets]

@v-yueyunzh-msft @vanessafvg 

Thank you both for your responses.

I have some sample data below, I am looking to combine the priorities into one column so I can filter by priority for all projects if this is possible, the projects are reported from different systems/data sources - 

Project	Data Source 1	Data Source 2
1	Priority 1
2	Priority 2
3	Priority 3
4	Priority 4
5		Priority 1
6		Priority 2
7		Priority 3
8		Priority 4
9		Priority 1
10		Priority 2

[vanessafvg]

so basically you are saying that you want to combine these, but there will only ever be one value in each column correct?

you can add a conditional column in power query see attach