Rearranging Data

N

NerdYorker

Hi,

I have 51 numbers in a row that I want to efficiently rearrange int
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 5
columns.

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

Thank You
 
Top