Copy formula question

[tjcase]

Trying to find a way to copy column A to 4 copies of each row to column B.

IS there a quick/easy way to do the following:

See excel attachment

[NBVC]

You can copy the text strings 4 times each, but the colours cannot be copied with Excel formulas..

in B2:

=INDEX($A$2:$A$4,MOD(INT((ROW()-ROW($A$2))/4),4)+1)

adust range to suit your data and copy down

[MarvinP]

The formula of
=INDIRECT("A"&1+CEILING((ROW()-1)/4,1))
in C2 and pull down works for me.

I don't know if Ceiling was in 2003. If not then you will need to find an equivalent rounding of my formula.
Looks like it was from http://www.techonthenet.com/excel/formulas/ceiling.php

[tjcase]

Thank all for the help. Much time saver for me!!!