how do I transpose a row of cells to a column between worksheets?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to transpose a row of cells (containing a formula) from one worksheet
into a column of cells in another worksheet. How do I do this?
 
Depending what is needed:
Use Copy followed by Edit | Paste Special with Transpose selected

or use the TRANSPOSE function - see Help for more then come back if you need
more
best wishes
 
=INDEX(Sheet1!$1:$1,ROWS($1:1))

Entered in A1 of Sheet2 and copied down column A



Gord Dibben MS Excel MVP
 
Back
Top