Unpivot columns

[Anonymous]

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

[PhilipTreacy · Accepted solution]

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]

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!

[PhilipTreacy]

No worries.