Merge two columns to one

H

HmxPete

I've seen others asking the same question, but none seem to fit my scenerio.

I need to merge two column into one, this is what I have;
A1 | B1
A2 | B2
A3 | B3

This is what I want;
A1
B1
A2
B2
A3
B3

Is there an easy to accomplish this task?


Thanks in advance,
Pete
 
J

JE McGimpsey

One way:

C1: =INDEX(A:B,ROW()/2+1/2,2-MOD(ROW(),2))

Copy down as far as required.
 
H

HmxPete

JE,
That did exactly what I needed, thank you very much for the help and quick
response.


Pete
 
Top