repeating data

M

matmich

I need to submit a list of locations to our programmer which consists o
about 4170 rows. Is there any way to have this list generated by
formula since there is a pattern to the repetition.

col level slot

39 1 a
39 1 b
39 1 c
39 2 a
39 2 b
39 2 c
41 1 a
41 1 b
41 1 c
41 2 a
41 2 b
41 2 c

This is the general format of what I need to submit -- actually
for every col there are 10 levels and each level has slot a-f and
have 132 columns also the columns are odd number
 
F

Frank Kabel

Hi
what's the starting point for your column number. If it's '1' try the
following formulas:
A1:
=1+INT((ROW()-1)/60)*2

B1:
=1+MOD(INT((ROW()-1/6),6)

C1:
=CODE(97+MOD(ROW()-1,6))

copy these formulas down for all required rows. After this you may copy
this range and paste it again with 'Edit - Paste Special - Values' to
remove the formulas
 
Top