| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Repeat data | Excel Discussion (Misc queries) | |||
| Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
| Auto Repeat Data | Excel Worksheet Functions | |||
| Auto Repeat Data | Excel Worksheet Functions | |||
| Repeat Paste of Data | Excel Worksheet Functions | |||
Hybrid Mode
