Hi,

Good day!

I want to drag a formula from a horizontal cell but I want to paste it in a vertical cells.

Example: I want to drag a formula in cell A4 to A27 from cell A1 to X1.

cell A4 = A1
cell A5 = B1
.
.
.
cell A27 = X1