# Thread: One Column to Multiple Columns at Interval (snaking columns)

1. ## One Column to Multiple Columns at Interval (snaking columns)

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.

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

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

3. 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/show...ltiple-columns

4. Originally Posted by 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/show...ltiple-columns
Thanks!

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

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

Alan

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•