Formuala Question

  • Thread starter Thread starter Rob
  • Start date Start date
R

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 said:
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)
Click to expand...
 
In C1:
=INDIRECT(IF(ISODD(ROW()),"A","B")&CEILING(ROW()/2,1))
copy down the column
best wishes
 
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
 
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
 
Try this:

Entered in D1 and copied down as needed.

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

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