merging columns

[merging columns]

hello

i have two adjacent columns with data in, and want to
merge them so i get a single column with the data in the
form:

A1
B1
A2
B2
A3
B3....

can anyone help??

cheers

iain

 

[gredis]

Try the formula in say cell C3

=A3&" "&B3

This will merge the data. Copy the formula down to merge the data in the
other rows.

Assume that you have 20 rows to merge. Select column C, choose copy,
paste Special Paste value will convert the formula to data.

 

[Iain]

thanks for the help. i may not have been too clear, but i
want the two data points from the two columns to be in
different cells, one under the other - this puts them in
the same cell. any suggestions??

cheers

 

[Anon]

i have two adjacent columns with data in, and want to

merge them so i get a single column with the data in the
form:

A1
B1
A2
B2
A3
B3....

can anyone help??

One way:

In C1 put this formula:
=OFFSET($A$1,INT((ROW()+1)/2)-1,MOD(ROW()+1,2))
and copy it down column C as far as you need.

 

[Paul Corrado]

Iain,

Insert a column between A & B

Fill the new column B with 1,3,5,7,9..... down to the bottom of your data

Fill column D with 2,4,6,8,....

Move columns C&D to the bottom of your data in columns A&B

Sort on column B

HTH

PC