Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transpose?
Welcome & thanks for feeding back
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Lucas Ramirez" wrote in message ... Great help!.Thanks Max.Lucas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose from Col to row | Excel Discussion (Misc queries) | |||
TRANSPOSE | Excel Discussion (Misc queries) | |||
Want to Transpose | Excel Discussion (Misc queries) | |||
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
Transpose | Excel Worksheet Functions |