One Column to Multiple Columns at Interval (snaking columns)

Nick Burns

Member
Joined
May 24, 2017
Messages
162
Reaction score
0
Points
16
Excel Version(s)
Office 365
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:

Column1Column2Column3Column4
13069160231701217142
14249160441703617155
14272160451706717163
16010160701709617177
16022161031712317182

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

Attachments

  • SnakingColumns.xlsx
    12.6 KB · Views: 5
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))
 
Back
Top