Forum Discussion

GDE's avatar
GDE
Regular Visitor
6 years ago
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!
  • robrog37's avatar
    6 years ago

    Table.ToRows(Table.FromList(List))

  • mapelli's avatar
    3 years ago

    = List.Zip( { your_list } )

    example: List.Zip( { {1, 2, 3} } ) = { {1}, {2}, {3} }