Put this in C1:
=INDEX(A:A,(ROW()+1)/2)
Put this in C2:
=INDEX(b:b,(ROW()+1)/2)

Select C1:C2
and drag down until you run out of data.

And maybe....

Select column C
edit|copy
edit|Paste special|Values

and delete columns A:B

jbly wrote:

I have two columns of data that I want to put into one column, alternating
the second column cells between the first column cells.
Like this:
A1
A2
B1
B2
C1
C2

Please help.

--

Dave Peterson