Forum Discussion
Beginner question : Table (Transpose and Pivot?)
I would first Split by Delimiter using the "/", and then split the table into a bunch of two row tables using Table.Split, with 2 as the parameter. This gives you a list of two row tables.
Then I would Promote headers on the nested Tables, then reorder the columns in the nested tables.
The promote headers and reorder steps are:
Split1 = List.Transform(PriorStepName, each Table.PromoteHeaders(_))
Reorder = List.Transform(Split1, each Table.ReorderColumns(_, {"ID, "Category", "Product", "Daily Goal"}))
Now you can expand the list into a single table.
--Nate
I would first Split by Delimiter using the "/", and then split the table into a bunch of two row tables using Table.Split, with 2 as the parameter. This gives you a list of two row tables.
Then I would Promote headers on the nested Tables, then reorder the columns in the nested tables.
The promote headers and reorder steps are:
Split1 = List.Transform(PriorStepName, each Table.PromoteHeaders(_))
Reorder = List.Transform(Split1, each Table.ReorderColumns(_, {"ID, "Category", "Product", "Daily Goal"}))
Now you can expand the list into a single table.
--Nate
Thank you a lot ! I didn't know those formulas and they are very easy to understand and apply, I was able to understand very fast and use it everywhere I was stuck! Thank you