Repeating sequential pattern

**Bdown** · 06-07-2012, 04:44 PM

I need to do the following:

1 a
1 b
1 c
2 a
2 b
2 c

but, the numbers repeat 14 times and go from 1-46. the letters will be repeating text entries. I will be using this fileCodes_SizeClass.xlsx as a table that will be used in a query in access.
I attached the excel file. In case your are wondering, the numbers are unique id's for fish species, and the text are size classes.

**roki4** · 06-07-2012, 04:51 PM

In terms of the a b c, select all three cells at once and just copy down.

**NBVC** · 06-07-2012, 04:56 PM

In A2:

=MOD(INT((ROW()-ROW($A$1)-1)/14),46)+1

copied down as far as you need to get to 46

copy one group of classes, say to D2:D15,

then in B2:

=INDEX($D$2:$D$15,MOD(ROW()-ROW($A$1)-1,14)+1)

copied down same distance.

edit: or what Roki4 said above for the text strings...