Repeat row data
 

Looking to convert column A into column B:

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

Thanks!

Repeat row data
 

Hi RussG
Maybe I'm missing something here, but why not select all Cut/Paste
HTH
John
"RussG" wrote in message
...
Looking to convert column A into column B:

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

Thanks!

Repeat row data
 

RussG wrote:
Looking to convert column A into column B:

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

Thanks!

In B1 and fill down:

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

Repeat row data
 

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)




"John" wrote:

Hi RussG
Maybe I'm missing something here, but why not select all Cut/Paste
HTH
John
"RussG" wrote in message
...
Looking to convert column A into column B:

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

Thanks!

Repeat row data
 

exactly what I was looking for. Thanks much!

"smartin" wrote:

RussG wrote:
Looking to convert column A into column B:

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

Thanks!

In B1 and fill down:

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