Thread: Transpose?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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