Transpose?
 

Hi'
From columns A and B I would like to show on col C,
C1=A1
C2=B1
C3=A2
C4=B2 and so on
Can you help with a formula?
Many thanks
Lucas Ramirez

Transpose?
 

One way ..

Put in C1:
=OFFSET(A$1,INT((ROW()-1)/2),MOD(ROW()-1,2))
Copy down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lucas Ramirez" wrote:
Hi'
From columns A and B I would like to show on col C,
C1=A1
C2=B1
C3=A2
C4=B2 and so on
Can you help with a formula?
Many thanks
Lucas Ramirez

Transpose?
 

Great help!.Thanks Max.Lucas

"Max" wrote:

One way ..

Put in C1:
=OFFSET(A$1,INT((ROW()-1)/2),MOD(ROW()-1,2))
Copy down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lucas Ramirez" wrote:
Hi'
From columns A and B I would like to show on col C,
C1=A1
C2=B1
C3=A2
C4=B2 and so on
Can you help with a formula?
Many thanks
Lucas Ramirez

Transpose?
 

Another way ... non-volatile ... and ... can be entered *anywhere* and
copied down:

=INDEX(A:B,ROWS($1:2)/2,MOD(ROWS($1:1)-1,2)+1)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Lucas Ramirez" <Lucas wrote in message
...
Hi'
From columns A and B I would like to show on col C,
C1=A1
C2=B1
C3=A2
C4=B2 and so on
Can you help with a formula?
Many thanks
Lucas Ramirez

Transpose?
 

"Ragdyer" wrote...
Another way ... non-volatile ... and ... can be entered *anywhere* and
copied down:

=INDEX(A:B,ROWS($1:2)/2,MOD(ROWS($1:1)-1,2)+1)
....

A bit better to make it

C1:
=INDEX(A$1:B1,(ROWS(C$1:C1)+1)/2,2-MOD(ROWS(C$1:C1),2))

and fill that down. That way changes in A:B or 1:<whatever won't
cause these formulas to recalculate unnecessarily.

Transpose?
 

Welcome & thanks for feeding back
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Lucas Ramirez" wrote in message
...
Great help!.Thanks Max.Lucas