Thanks everyone for the input...
This initial solution ended up working and easy, on Office 2021.
Quote:
Try
=INDEX(range, SEQUENCE(rows, columns))
Where
Range is your 1 column range holding your data
Rows is the number of rows you are expecting in the output. This should simply be number of rows in your input data dividee by 3
Columns is the number of columns you require in your output. This is 3 for you.
This will end up something like
=INDEX(A2:A301, SEQUENCE(100, 3))
Note that is assumes you are using a version of Excel that includes the SEQUENCE function.
Or if you have the newest version of Excel 365
=WRAPROWS(A2:A301, 3)
|