Forum Discussion
Require Help to Move Column Value to Column header in POWER QUERY
- 5 years ago
Hello PijushRoy
you can apply some Table.Group by grouping by parameter and create a list from the measure column. In the second step a Table.FromColumns is used to us the data from the grouping-step to create your new table
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8knNSy/JUNJRMq4wNlUIDvT1VYrVQRE2NcAqbI5d2BK7IYZG2JUb4jDd0AK7OUYm2NUbG2AXN0EWD0osSU1RcCtKLSxNzUuuBCoA2u5RNeLlwvJzShLTUxXcixJTUoEyZnrGpvqGhiNbLhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Parameter = _t, Measure = _t]), ChangeType = Table.TransformColumnTypes(Source,{{"Parameter", type text}, {"Measure", type text}}), GroupYourData = Table.Group(ChangeType, {"Parameter"}, {{"Measures", each _[Measure], type table [Parameter=text, Measure=text]}}), CreateYourTable= Table.FromColumns ( GroupYourData[Measures], GroupYourData[Parameter] ) in CreateYourTableCopy paste this code to the advanced editor in a new blank query to see how the solution works.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hi PijushRoy ,
Go To Transform tab and select the first column and then do a Transpose.
That would solve your problem.
Appreciate your kudos!!! Please mark my post as solution if this helps you.
- PijushRoy5 years agoCommunity Champion
Ilalready try and get the result as below snap
but I require below format
Length Rated Frequency Voltage Grade 3x35 SQMM 50 Hz 6.35/11 3x50 SQMM 50 Hz 6.35/11 3x70 SQMM 50 Hz 6.35/11 3x95 SQMM 50 Hz 6.35/11 3x120 SQMM 50 Hz 6.35/11 3x150 SQMM 50 Hz 6.35/11 3x185 SQMM 50 Hz 6.35/11 3x240 SQMM 50 Hz 6.35/11 3x300 SQMM 50 Hz 6.35/11 3x400 SQMM 50 Hz 6.35/11