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