insert every other column from other excel cells

[sabrina]

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

 

[Guest]

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.

 

[D Hilberg]

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.