Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Unpivot columns

Dear Community,

 

I would like to ask for some help with my problem.

I have some files coming to me in the format attached (Start sheet). It's not the most efficient format to use...
I would like to apply some transformation in Power BI to get a table that you can find on the End Result sheet. I was trying to use the unpivoting function, but those blank cells are giving me a headache!

 

File 

 

Any help is appreciated!

Thanks

Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi Anonymous 

    Please see this Excel workbook for solution

    Regards

    Phil

    If I answered your question please mark my post as the solution.
    If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

3 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    Hi Anonymous 

    Please see this Excel workbook for solution

    Regards

    Phil

    If I answered your question please mark my post as the solution.
    If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks PhilipTreacy , it does the trick!

      Transpose step was missing in my logic and that's why I couldn't solve it.

       

      Much appreciated your help!