Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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...
Need Help
  • hohlick's avatar
    hohlick
    10 years ago
    1. Transpose table
    2. Merge two first columns with delimeter
    3. Transpose again
    4. Promote headers
    5. Unpivot columns
    6. Split columns by the same delimeter
    7. Pivot by second part (where parameters is)
    8. Njoy
Funkmiester's avatar
Funkmiester
Advocate I
6 years ago

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

Really appreciate for your reply here. This really helps!

One more question, after appending the new table to the former one, what did you do to delete those rows that have been replaced with the new table?

 

Thanks,

Qinya