Can any one help me? I have a spreadsheet with the following data which I'm
trying to format into one group of 4 columns. Basically, I want a macro to
select and cut every 4 columns of data (from left to right) and paste them
all in columns A:D. My goal is to turn the horizontal data into more
readible verticle data. I know my description might not make sense to you,
but if you look data below you might be able to understand what I'm trying to
accomplish. I will need to use some sort of loop code to perform my task b/c
the verticle data in my spreadsheet is much larger than the sample I provided
here.

data currently in spreadsheet:

52200 R0646 54000 17625.9 52200 R0646 54001 0
52201 R0646 54000 0 52201 R0646 54001 0
52203 R0646 54000 0 52203 R0646 54001 0
52204 R0646 54000 10508.34 52204 R0646 54001 3950
52206 R0646 54000 0 52206 R0646 54001 0



Format I need:

52200 R0646 54000 17625.9
52201 R0646 54000 0
52203 R0646 54000 0
52204 R0646 54000 10508.34
52206 R0646 54000 0
52200 R0646 54001 0
52201 R0646 54001 0
52203 R0646 54001 0
52204 R0646 54001 3950
52206 R0646 54001 0


Any help would be appreciated.


--
Regards,

timmulla