formula to transpose

[oberon.black]

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

 

[RagDyer]

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" <[email protected]>
wrote in message
news[email protected]...

 

[RagDyer]

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

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" <[email protected]>
wrote in message