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!