Dragging a transpose of data

[Guest]

Is there a way to drag cells down that reference cells across. Here is an
example:

Column
A B C
Dog Cat Mouse

I would like to make a cell = A1 (Dog), then drag DOWN (across is standard)
so that A2 would equal Cat and A3 would equal Mouse.

A
Dog
Cat
Mouse

Thanks!

 

[Peo Sjoblom]

One way

=INDEX($1:$1,ROWS($A$1:A1))

copy down

You need to put this in A2, once you are done you can copy the formula and
paste special as values and delete the first row or else you will get a
circular reference error

 

[Guest]

I am unaware of being able to drag and have excel perform that command. What
works just as well is to highlight the range of data you want to drag, click
ctr+c (to copy), then in the cell beginning where you want your data right
click, choose paste special, choose transpose (bottom right of box) and click
ok, hit enter. The data will be transposed.