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

Hi olebor.

the link to screenshot is broken

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Sorry for broken link:

 

201520152015201520152015
January            ActualFebruary       ActualMarch        ActualYTD                  ActualYTD               BudgetBudget vs
Actual

 

 I want to combine first and second row.

  • 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks a lot, it worked perfectly!

    • geethaj's avatar
      geethaj
      Regular Visitor
      7 years ago

      Works great. Thanks for sharing