Combine the data in 2 columns of 20 rows into one column of 40 row
Hi Tom,
In column C, I'd do this:
In C1: =A1
In C2: =B1
Then highlight both C1 & C2 and drag down to C4000. The cell references are
relative, so it'll keep repeating as: A1, B1, A2, B2, etc. Then, I'd copy
column C, then Edit-Paste Special-Values to get rid of the formulae.
Cheers,
Pat
"Tom" wrote:
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
|