Forum Discussion
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...
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.
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.
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!
No worries.