You need to use Tools | Add-in and install the Analysis Toolpac
If you do not see it in the list, go to help and search "Load the Analysis
Toolpak"
It will work when you have the ATP loaded
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Rob" wrote in message
...
SORRY - It doesnt work !

I just get a #NAME error !

Rob


"Bernard Liengme" wrote:

In C1:
=INDIRECT(IF(ISODD(ROW()),"A","B")&CEILING(ROW()/2,1))
copy down the column
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Rob" wrote in message
...
Help:

Here is my data - need the results to alternate columns:

Column A Column B
7 R
9 C
8 J

How do I get this to populate in column C:
A1
B1
A2
B2
C1
C2

THANKS!
Rob