Transpose?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
One way ..

Put in C1:
=OFFSET(A$1,INT((ROW()-1)/2),MOD(ROW()-1,2))
Copy down as far as required
 
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)
 
Ragdyer said:
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)
Click to expand...
....

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.
 
Back
Top