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

  • Thread starter Thread starter john.laffe
  • Start date Start date
J

john.laffe

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