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
MarkS's avatar
MarkS
Resolver IV
9 years ago

I think that you should Transpose the Table,

then select the first 5 columns and choose the Unpivot Other Columns function,

then select Column 5 and Select Pivot Column (the values will be the Values column and choose Advanced Options "Don't Aggregate" from the drop down for the aggregate values function).

. This will get you to this

Then clean up the column names and data types.