A alldreams Jan 28, 2004 #1 is there a way to link data from a row to a colum? Any help will be appreciated.
F Frank Kabel Jan 28, 2004 #2 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
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
F Frank Kabel Jan 28, 2004 #3 Typo: correct formula in respect to the assumptions to =OFFSET($A$1,0,ROW()-2) Frank
