View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sabrina[_2_] sabrina[_2_] is offline
external usenet poster
 
Posts: 1
Default insert every other column from other excel cells

Hi, I have 3 data sets, A, B, C in 3 different sections of one Excel
sheet( I use Office 2003). They all have the same size. I want to re-
arrange the data in the following way:

A1, B1, C1, A2, B2, C2...

A1, means column 1 in A; since each has over 20 columns, I wonder if
there is an easy way to do it? Thanks