There are only two methods. Do it manually by cutting and inserting the
column or write a macro. By the time you write the macro you can do it
manually. You have to do trade-offs between the time, accuracy, and number
of times you perform these operations to determine when to write macros and
when to do it manually.

"sabrina" wrote:

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