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.