I have a string of data 5 columns wide and 7,200 rows long ( the rows have 60 pieces of info, 120 different categories...stacked on top of eachother...so 7,200 rows).
I need the data rearranged so that it is layed side by side instead of stacked on top...more specifically, I need 5 columns 60 rows deep of one category, and then right next to it another 5 columns and 60 rows of data on the next category...going to the right for all 120 categories.

I need a macro that will cut the 60 rows of 5 columns worth of data and paste it immediately adjacent to the 1st set...and so on until the very bottom 60 rows x 5 columns is now all the way at the right.

example:

x 1 2 3 4
x 1 2 3 4
x 1 2 3 4
y 1 2 3 4
y 1 2 3 4
y 1 2 3 4
z 1 2 3 4
z 1 2 3 4
z 1 2 3 4

x 1 2 3 4 y 1 2 3 4 z 1 2 3 4
x 1 2 3 4 y 1 2 3 4 z 1 2 3 4
x 1 2 3 4 y 1 2 3 4 z 1 2 3 4