macro/function to transpose

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

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.

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.

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
>
>