Transpose a List in Power Query

[GDE]

How do I Transpose a List like:

• {1, 2, 3}

into another List like:

• {{1}, {2}, {3}}

in Power Query?

Thanks in advance!

[robrog37 · Accepted solution]

Table.ToRows(Table.FromList(List))

[mapelli · Accepted solution]

= List.Zip( { your_list } )

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

[GDE]

IMHO, this is the best one, I've seen so far. 🙂

[mapelli]

Yeah... this is the equivalent to the transpose for lists.
I use it often with Table.RenameColumns; example:

let
Source = Table.FromRecords({
[name_1= "John", address_2= "CA", id_3= "john.doe@company.com"],
[name_1= "Juan", address_2= "MX", id_3= "juan.torres@factory.net"],
[name_1= "João", address_2= "BR", id_3= "joao.silva@empresa.com.br"]
}),

TransposedLists = List.Zip( { /* current column names: */ Table.ColumnNames(Source),
/* new col names */ { "firstName", "country", "email" }
} ),

RenamedCols = Table.RenameColumns(Source, TransposedLists)
in
RenamedCols

[Zubair_Muhammad]

@GDE 

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

[GDE]

Wow! That is a mighty function right there! A little (a lot) out of my leaugue...
Respect!

[AlB]

@GDE 

another option:

List.Transform( yourList_, each {_} )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[robrog37 · Accepted solution]

Table.ToRows(Table.FromList(List))