Forum Discussion
Solved
Combining two data columns into one in Power Query
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. ...
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
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 |
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