All,

My issue is that I have 2 columns of data, Column A and Column B. What
I would like to do is combine these 2 columns into 1 that would result
in something like this:

A1
B1
A2
B2
A3
B3
etc

There are 1000+ entries in each column and I have tried creating a 3rd
column plugging into the cells the following, hoping to create the
ability to click and drag and fill the rest of the relative values:

=A1
=B1
=A2
=B2
=A3
=B3
etc

However, when I click and drag, I am not able to keep the pattern
going. It always seems to revert to something like this after I try to
click and drag the fill box:

A1
A2
A3
A4

Any thoughts on a better way to accomplish this? Or perhaps a tip to
fill the pattern down the column? Sorry if I am missing something
totoally obvious.

Any help is appreciated!


--
mayhewvb
------------------------------------------------------------------------
mayhewvb's Profile: http://www.excelforum.com/member.php...o&userid=24352
View this thread: http://www.excelforum.com/showthread...hreadid=379488