Transpose cell references

[RSunday]

I have a comparison of 5 solutions on different parameters.

I have my solutions listed in rows with all the parameters in columns. There
are many parameters, so I exceed my page width.

For display I want to show the values with the 5 solutions as columns, and
then all the parameters as rows.

I have the data in cells like

A5
A6
A7
A8
A9

now I want that listed in cells
A10 A11 A12 A13 A14

i.e. in A10 I want "=A5", A11 "=A6" etc.

My question is: Can I somehow easily make these references to the cells in
the original listing - e.g. by dragging the window handle or similar... (when
I do that I get "=A5" "=B5" "= C6" etc.

 

[Pete_UK]

Put this formula in A10:

=INDIRECT("A"&COLUMN(E1))

then just copy it across into B10:E10.

Hope this helps.

Pete