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