link data

[alldreams]

is there a way to link data from a row to a colum?

Any help will be appreciated.

 

[Frank Kabel]

Hi
If you want a formula to transpose your row data to a column, you can
use the following (assumption: cells A1:X1 is the source and B2:Bx is
the target)
Insert the following in B2
=OFFSET($A$1,0,ROW()-1)
copy down

HTH
Frank

 

[Frank Kabel]

Typo:
correct formula in respect to the assumptions to
=OFFSET($A$1,0,ROW()-2)
Frank