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