Converting a column into a row??

  • Thread starter Thread starter Guest
  • Start date Start date
G

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??
 
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??
Click to expand...

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)
 
Back
Top