Hello,

I have a rather large Excel document that was exported from an old
database. The data contains 1 unique key (1) and 2 other data feilds
(2, 3). However, the export was originally meant just for print
reports, so instead of there being 3 columns with 3000 rows with the
data going down, there are 90 columns with 33 or so rows.

So instead of (what I want):
1 2 3
1 2 3
1 2 3
1 2 3
1 2 3
1 2 3
1 2 3
1 2 3
1 2 3
1 2 3

The excel document contains (what it is):
1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3
1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3
1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3
1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3 1 2 3

Does anyone know of a macro or something that will make it so that
every 3 columns will be cut and pasted under the first column? So
coulmns 4-6 will be pasted under the last entried in column 1-3,
columns 7-9 will be pasted under ther last entries of 1-3, etc.

Thank you for your help.


--
rashly
------------------------------------------------------------------------
rashly's Profile: http://www.excelforum.com/member.php...o&userid=24723
View this thread: http://www.excelforum.com/showthread...hreadid=382899