Forum Discussion

LouStagner's avatar
LouStagner
Frequent Visitor
9 years ago
Solved

Transformation conundrum!

I have a Power Query transformation I am trying to do that I am stuck on.  I have 2 pictures below showing what the data currently looks like and an after picture that shows what I need to turn it in...
Need Help
GilbertQ's avatar
GilbertQ
Super User
9 years ago

I would suggest to Transpose your Columns first.

 

Then once that is done you possibly then can Unpivot some other columns and then that should get it into the format you need.

 

I have personally done it in the past where I have Transposed, Unpivoted and Transposed again.

LouStagner's avatar
LouStagner
Frequent Visitor
9 years ago

Thanks for your feedback,

 

I am still having no luch trying to make this work through a combination of trasnforms and pivot/unpivot.

 

There has got to be a way, but whatever that way is, I can't figure it out!