Thread: Repeat row data
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
smartin smartin is offline
external usenet poster
  
Posts: 915
Default 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))
Reply With QuoteReply With Quote