Dragging Hori/Verti!!!

[buddy1000]

hi...

In column A I have values vertically. (A1: A100)

i link D1 to A1.
If I drag it horizontally it does not gives the correct values.
Is it possible to drag it in a correct way?

 

[Richard Schollar]

Perhaps using a formula like:

=INDEX($A:$A,COLUMNS($A$1:A$1))

draged across from column D.