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