One Column to Multiple Columns at Interval (snaking columns)

[Nick Burns]

My full list will be over 1000 items and I'd like to split it into groups of 33 (obviously the last column will not have the full count)

Attached is just a sample, I would like to take one column and split it into multiple columns at a set interval of 20 items into 4 groups of 5.

#
13069
14249
14272
16010
16022
16023
16044
16045
16070
16103
17012
17036
17067
17096
17123
17142
17155
17163
17177
17182

Into this:

Column1	Column2	Column3	Column4
13069	16023	17012	17142
14249	16044	17036	17155
14272	16045	17067	17163
16010	16070	17096	17177
16022	16103	17123	17182

Basically a function that will take a column and a number and it will parse that column into multiple columns contain n-items.

 

[Nick Burns]

Well...dang, answering my own question again....looking through the docs (#shared) List.Split() is what I need.

= Table.FromColumns(List.Split(Source[#"#"],5))

 

[pinarello]

In post #12 of the following link you will find a solution where you can flexibly specify how many columns or rows should be generated.


https://www.excelguru.ca/forums/sho...-column-(NO-delimiters)-into-multiple-columns

 

[Nick Burns]

In post #12 of the following link you will find a solution where you can flexibly specify how many columns or rows should be generated.


https://www.excelguru.ca/forums/sho...-column-(NO-delimiters)-into-multiple-columns

Thanks!

The List.Split() accomplishes the same task and worked perfectly for me.

 

[alansidman]

Nick,
Thanks for your simple solution. Very much liking this!!

Alan