Dragging a transpose of data
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.
"RLind" wrote:
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!
|