Forum Discussion
Solved
Transpose a List in Power Query
How do I Transpose a List like: {1, 2, 3} into another List like: {{1}, {2}, {3}} in Power Query? Thanks in advance!
Table.ToRows(Table.FromList(List))
= List.Zip( { your_list } )
example: List.Zip( { {1, 2, 3} } ) = { {1}, {2}, {3} }
let
Source = {1, 2, 3},
New= List.Generate(()=>[a={},b=0], each [b] <= List.Count(Source), each [a={Source{b}},b=[b]+1], each [a])
in
New
Wow! That is a mighty function right there! A little (a lot) out of my leaugue...
Respect!