Sorry, you're right. I have column and row headings backwards. It should be
A1
B1
A2
B2
A3
B3

I thought the letters were rows, my bad.

"jbly" wrote:

I believe that is two columns, correct? My example has 3 rows with 2 columns.
Make
A1 A2
B1 B2
C1 C2

into

A1
A2
B1
B2
C1
C2

I'll try the other response to see if it works. Thanks for your help.

"David Biddulph" wrote:

What you've listed are two rows of data, not two columns. Which do you want
to process?
--
David Biddulph

"jbly" wrote in message
...
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.