Forum Discussion
Help pls, help
How to create new table with data from another existing table
Tablea 1 (Existing)
| ID | Name | Value |
| 1 | A | X |
| 1 | B | Y |
| 2 | A | Z |
| 2 | B | W |
Table 2 (New)
| ID | A | B |
| 1 | X | Y |
| 2 | Z | W |
Hi Anonymous
Select the Name column in Power Query and pivot it with the Value column as values
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXIE4gilWB0IzwmII8E8I6hcFJwHkgtXio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Name = _t, Value = _t]), #"Pivoted Column" = Table.Pivot(Source, List.Distinct(Source[Name]), "Name", "Value") in #"Pivoted Column"Regards
Phil
4 Replies
Hi Anonymous
Select the Name column in Power Query and pivot it with the Value column as values
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUXIE4gilWB0IzwmII8E8I6hcFJwHkgtXio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Name = _t, Value = _t]), #"Pivoted Column" = Table.Pivot(Source, List.Distinct(Source[Name]), "Name", "Value") in #"Pivoted Column"Regards
Phil
Anonymous Try to use Matrix visual and add the fields like below:
Anonymous and if you don't want the total column at the end so you can set it off like this:
