Thread: Combine multiple columns into two long columns, Repeating rows in first column
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
excelent excelent is offline
external usenet poster
  
Posts: 695
Default Combine multiple columns into two long columns, Repeating rows
another way
names:
=OFFSET(A$1,ROUNDUP(CELL("row",A1)/4,0),0)
numbers:
=OFFSET($A$1,ROUNDUP(CELL("row",A1)/4,0),IF(MOD(CELL("row",A1),4)=0,4,MOD(CELL("row",A 1),4)))


Reply With QuoteReply With Quote