Formuala Question

[Rob]

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

 

[Rob]

ADDITIONAL DATA TO CONFIRM MY QUESTION:

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:
7 (A1)
R (B1)
9 (A2)
C (B2)
8 (A3)
J (B3)

 

[Bernard Liengme]

In C1:
=INDIRECT(IF(ISODD(ROW()),"A","B")&CEILING(ROW()/2,1))
copy down the column
best wishes

 

[Rob]

SORRY - It doesnt work !

I just get a #NAME error !

Rob

 

[Bernard Liengme]

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

 

[Rob]

It works - but one more quick question....what if I wanted to add an extra
column?

Ie - Data in the following Colums (A,B,C) and the desired result in Column D:

A B C
1 2 F
3 P G
5 3 O

Desired result in Column D:

1 (A1)
2 (B1)
F (C1)
3 (A2)
P (B2)
G (C2)
5 (A3)
3 (B3)
O (C3)

THANKS SO MUCH FOR YOUR HELP!
Rob

 

[T. Valko]

Try this:

Entered in D1 and copied down as needed.

=OFFSET(A$1,INT((ROWS(D$11)-1)/n),MOD(ROWS(D$11)-1,n))

Where n = the number of columns you have. In your case n = 3

 

[Roger Govier]

Hi Rob

One way
=INDEX(A:C,INT((ROW()-1)/3)+1,MOD(ROW()-1,3)+1)