Moving data from 3 columns to next 3
 

I have a long list of data in columns A, B & C.
The data is sorted by column C and contains the number 1 for so many
rows, and then 2 and so on.
What I need to do is cut and paste the data from columns A, B & C to E,
F & G when C changes to 2 and then H, I & J when it changes to 3 and so
on.
How can I automate this.


--
macke
------------------------------------------------------------------------
macke's Profile: http://www.excelforum.com/member.php...o&userid=32445
View this thread: http://www.excelforum.com/showthread...hreadid=522215