Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro/function to transpose
I have a excel xls that I will create into a very large project. th setup is as follows for my test. a1 = 1 b1 = 2 c1 = 3 d1 = 4 I then want: e1 = a1 so i put =a1 in cell e1, however I want e2 to = b1, and e3 to = c1 an so on. I do not want to manually insert =(cell) in each cell that I want t transpose to. So what kind of formula could I use to complete thi task. I would like to drag formula down the e column. Please help. I have no idea on how to write such a formula pleas construct. Thank -- oberon.blac ----------------------------------------------------------------------- oberon.black's Profile: http://www.excelforum.com/member.php...fo&userid=2673 View this thread: http://www.excelforum.com/showthread.php?threadid=47925 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro/function to transpose
You could use the TRANSPOSE function.
If your worksheet contains a1 = 1 b1 = 2 c1 = 3 d1 = 4 then enter '=TRANSPOSE(A1:D1)' into cell E1, but instead of pressing Enter, press Ctrl+SHift+Enter to make it an array formula. This will put curly braces around the formula, and E1:E4 will equal A1:D1. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro/function to transpose
You could use the TRANSPOSE function.
If your worksheet contains a1 = 1 b1 = 2 c1 = 3 d1 = 4 then enter '=TRANSPOSE(A1:D1)' into cell E1, but instead of pressing Enter, press Ctrl+SHift+Enter to make it an array formula. This will put curly braces around the formula, and E1:E4 will equal A1:D1. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro/function to transpose
refer to the function "OFFSET"
just put in e1 like this: =OFFSET($A$1,0,ROW(A1)-1) then... drag em down :D "oberon.black" wrote: I have a excel xls that I will create into a very large project. the setup is as follows for my test. a1 = 1 b1 = 2 c1 = 3 d1 = 4 I then want: e1 = a1 so i put =a1 in cell e1, however I want e2 to = b1, and e3 to = c1 and so on. I do not want to manually insert =(cell) in each cell that I want to transpose to. So what kind of formula could I use to complete this task. I would like to drag formula down the e column. Please help. I have no idea on how to write such a formula please construct. Thanks -- oberon.black ------------------------------------------------------------------------ oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732 View this thread: http://www.excelforum.com/showthread...hreadid=479255 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose function | Excel Discussion (Misc queries) | |||
Transpose Function | Excel Worksheet Functions | |||
Transpose Function? | Excel Worksheet Functions | |||
Transpose Function | Excel Worksheet Functions | |||
How do I use the Transpose Function | Excel Worksheet Functions |