R
RussG
Looking to convert column A into column B:
A B
RED RED
GREEN RED
BLUE RED
GREEN
GREEN
GREEN
BLUE
BLUE
BLUE
Thanks!
A B
RED RED
GREEN RED
BLUE RED
GREEN
GREEN
GREEN
BLUE
BLUE
BLUE
Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John
Hi RussG
Maybe I'm missing something here, but why not select all Cut/Paste
HTH
John
Maybe I'm missing something here, but why not select all Cut/Paste
HTH
John
S
smartin
RussG said: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))
R
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)
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)
R
RussG
exactly what I was looking for. Thanks much!
smartin said:In B1 and fill down:
=INDEX($A$1:$A$3,1+INT((ROW()-1)/3))