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

insert every other column from other excel cells
 

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

insert every other column from other excel cells
 

Here's a good compromise.

Assuming the data sets are already lined up (row-wise), are already in
A, B, C, order, and there are no extra data columns between those sets
(blank columns ok)...

- Temporarily insert a blank row at top (if necessary).
- For each data set, use the blank row to number its columns 1 through
20 (whatever).
- Select all columns encompassing all sets.
- Sort, with sort Options set as "left to right."

The end result will be 1 1 1 ... 2 2 2 ... ... 20 20 20.

If the data sets are not already in A, B, C order, then before sorting
add a second blank row. Fill it with a's, b's and c's as appropriate,
and use it as a 2nd sort key.







On Jul 5, 9:51 am, 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