View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kelly E.
 
Posts: n/a
Default concatenate every second row to first row

I have a dataset that contains an array of data values. The first row
contains the header information (A1:W1) for the data and the second row
contains the data (A2:IU2). This combination is repeated over 2400 times in
one file. I would like to add the second line of data to the first line of
attributes and repeat over the length of the file (down to row 4822), so that
I can then import the data into a GIS. Anyone have any suggestions on how
best to do this?
Thanks!
Kelly