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
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
this worked like a charm for me too. Thanks!
