Repeat row data

[RussG]

Looking to convert column A into column B:

A B
RED RED
GREEN RED
BLUE RED
GREEN
GREEN
GREEN
BLUE
BLUE
BLUE

Thanks!

 

[John]

Hi RussG
Maybe I'm missing something here, but why not select all Cut/Paste
HTH
John

 

[RussG]

Sorry, to clarify:

Column A has many non-repeating values (i.e. RED, GREEN, BLUE,...,n) - too
many to simply copy/paste.
I would like to create a Column B where each row is a Column A value,
repeated x number of times, thus:

Column B (cell reference)
RED (A1)
RED (A1)
RED (A1)
GREEN (A2)
GREEN (A2)
GREEN (A2)
BLUE (A3)
BLUE (A3)
BLUE (A3)
n (An)
n (An)
n (An)

 

[RussG]

exactly what I was looking for. Thanks much!

In B1 and fill down:

=INDEX($A$1:$A$3,1+INT((ROW()-1)/3))