I have a large amount of data in 4 columns in the format of:

1 2 3 4 header
AA 01 A 1
AA 01 A 2
AA 01 A 3
AA 01 B 1
AA 01 B 2
AA 01 B 3
AA 01 C 1
AA 01 C 2
AA 01 C 3
AA 01 D 1
AA 01 D 2
AA 01 D 3

The data in column 4 alternates 1,2,3 for the whole selection
The data in column 3 alternates as such between A,B,C and D
The data in column 2 goes up 1 every time until it gets to 10 and then
column 1 changes to AB and so on until it gets to the letters AF so in
total there will be 18720 records in total. If someone can think of
some way of automating this it would come in very handy.

Cheers,
Mike