View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tom
 
Posts: n/a
Default Combine the data in 2 columns of 20 rows into one column of 40 row

I want to combine the data in 2 columns each of 2000 rows in to 1 column of
4000 rows. I want the data to end up in the order A1, B1, A2, B2 and so on.
Any help would be great!
Cheers Tom