formula 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


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=479217

formula to transpose
 

Maybe you started with a bad example.

You can only go down Column E for 4 cells since you'll then run into the
contents of E1, where you started from ... right ? ? ?

So, guessing that you want to drag a formula *down* a column and reference
the contents of a row, let's try this scenario:

A1 to AX1 contains the numbers 10 to 500.

To copy those values down Column E, starting at E2,
enter this formula in E2 and drag down to copy as needed:

=INDEX($1:$1,ROW(1:1))

If the values were in A5 to AX5,
then starting in E6 you would use:

=INDEX($5:$5,ROW(1:1))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"oberon.black"
wrote in message
news:oberon.black.1xh22j_1130267135.1302@excelforu m-nospam.com...

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

formula to transpose
 

The subject line *does* say "formula", but just to make sure ... you *do*
realize that you can perform a transpose copy, without the need of formulas,
don't you?

Select A1 to AX1,
Right click in the selection and choose "Copy",
Right click in E2 and choose "Paste Special",
Click on "Transpose",
Then <OK.

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------


"RagDyer" wrote in message
...
Maybe you started with a bad example.

You can only go down Column E for 4 cells since you'll then run into the
contents of E1, where you started from ... right ? ? ?

So, guessing that you want to drag a formula *down* a column and reference
the contents of a row, let's try this scenario:

A1 to AX1 contains the numbers 10 to 500.

To copy those values down Column E, starting at E2,
enter this formula in E2 and drag down to copy as needed:

=INDEX($1:$1,ROW(1:1))

If the values were in A5 to AX5,
then starting in E6 you would use:

=INDEX($5:$5,ROW(1:1))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"oberon.black"
wrote in message
news:oberon.black.1xh22j_1130267135.1302@excelforu m-nospam.com...

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