Thread: Repeat row data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default 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!