Forum Discussion
Merge 2 rows in one row
I would like to know, if there is possibility in Power Query to combine two rows in one. I have been investigating this and I could not find the solution. What I am trying to do is in the attached p...
- Transpose table
- Merge two first columns with delimeter
- Transpose again
- Promote headers
- Unpivot columns
- Split columns by the same delimeter
- Pivot by second part (where parameters is)
- Njoy
For larger datasets
Duplicate
Filter to keep the rows you want to merge
Then Transpose, merge,Transpose back
Append as new
Sort to bring in your header to top
Promote new header
A bit late to the party, but a big thank you, Funkmiester! You saved me some serious manual steps.