how do i copy data and formula from a column to a row in another?
 

i have a worksheet that has data and formulas in a column, how do i link this
data and formulas to another worksheet but the data is now to be in a row?

how do i copy data and formula from a column to a row in another?
 

Say original data are A2:A11 and B2:B11 (formulas) (this is a 10x2
array). Say you want them transposed starting from C1.
Select a 2x10 array (reverse the dimensions). Then type:

=TRANSPOSE(A2:B11)

Commit with Shift+Ctrl+Enter

Does this help?
Kostis Vezerides

On Dec 11, 8:14 pm, john.laffe
wrote:
i have a worksheet that has data and formulas in a column, how do i link this
data and formulas to another worksheet but the data is now to be in a row?