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.
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 |