Formuala Question
 

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

Formuala Question
 

"Rob" wrote:

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)

THANKS!
Rob

Formuala Question
 

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

Formuala Question
 

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

Formuala Question
 

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

Formuala Question
 

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







"Bernard Liengme" wrote:

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

Formuala Question
 

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

--
Biff
Microsoft Excel MVP


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







"Bernard Liengme" wrote:

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

Formuala Question
 

Hi Rob

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

--
Regards
Roger Govier

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







"Bernard Liengme" wrote:

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