How to move contents from cell D1 to cell A2.

[Davitzin28]

I have over 6500 rows of data. In Columns A through C for each line I have data for boys name, and then similar data for the girls' name on the same line in columns D through F. I have inserted a blank line after each of the more than 6500 lines because I need to move the data in columns D through F down to the next line and over to columns A through C. Can anybody help me put together a macror for this problem?

Thank you!

Davitzin

[martindwilson]

you dont really need a macro just a bit of sorting. without adding rows
1. insert a new column d and number down to end of data in cols a-c
2. after girls names in the next col now h number similarly
3. copy all data from columns e-h paste below a-d
4select cols a-d
5, sort by column d
6 delete d-h

[Davitzin28]

Gracias! I don't use Excel that much, so your help is much appreciated!