Forum Discussion
Solved
Reorder data with Power Query repeating words
Hi to all! I have this data: Pais Aire Agua Tierra Fuego Colombia 1 3 2 Argentina 2 2 1 México 1 1 2 Perú 1 3 1 And I like to transform with ...
Unpivot all but the first columns,
add a column with nested lists with the numbers {1 thru Value},
expand this column,
remove this column and the Value column,
adjust the header Attribute to Objeto as illustrated in this video.
Unpivot all but the first columns,
add a column with nested lists with the numbers {1 thru Value},
expand this column,
remove this column and the Value column,
adjust the header Attribute to Objeto as illustrated in this video.
Great MarcelBeug! Works like a charm. Blessings to you!
