Converting a column into a row??

[Guest]

Hi,

I need to create many rows of data where each cell in a
row references a cell in a column, ie cells X1 Y1 Z1
reference cells A1 A2 A3.

Is there a way drag the formula in X1, =$A1, horizontally
across the row so the numbered row reference increases??

 

[Paul]

Hi,

I need to create many rows of data where each cell in a
row references a cell in a column, ie cells X1 Y1 Z1
reference cells A1 A2 A3.

Is there a way drag the formula in X1, =$A1, horizontally
across the row so the numbered row reference increases??

You cannot do exactly as you ask.
However, you can put this formula in X1 and drag it horizontally across Y1,
Z1.... to achieve what you want.
=OFFSET($A$1,COLUMN(X1)-COLUMN($X$1),0)