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
hohlick's avatar
hohlick
Continued Contributor
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
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Great Maxim, 

 

This is it. I haven't used transpose, but from now on, this will be my daily function :). 

 

Have a great day, Borut