Hi,

I have 51 numbers in a row that I want to efficiently rearrange into columns in groups of three.

EXAMPLE DATA

Current arrangement: 1 2 3 4 5 6 7 8 9

Desired arrangement:
123
456
789


I have over 300 rows that are arranged like this and a total of 51 columns.

I tried TRANSPOSE but I am not sure that is the best method. Any help is greatly appreciated!

Thank You!