View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
C.O. C.O. is offline
external usenet poster
 
Posts: 2
Default Quickly moving rows of 5-column groups on 1 continuous line

I've got a worksheet with about 50+ rows of 5-column's worth of numbers (a
5x50 grid). I'm trying to turn this into 1 continuous row that uses data
from A1, B1, C1, D1, E1, A2, B2, C2, D2, E2, A3, B3...

Is there any way to automate some of this? Thanks.