And I've confused the issue further by quoting the wrong column number. I
meant to say "However you have shown column 2 staying static as 01"

"Rowan" wrote:

Mike

Can you clarify a few things. In your post you said:

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

However you have shown column 1 staying static as 01. Also the example below
shows AA repeated for 12 rows which makes sense considering you want to
repeat A,B,C,D 3 times each. But in the discription above you have said AA
should change to AB after 10 rows not 12.

Obviously I have not grasped what you are after as 12 rows by AA,AB,AC,AD,AE
and AF only gives me a total of 72 rows.

Regards
Rowan

"Mike G" wrote:

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