TRANSPOSE(array) returns the transpose of an array : TRANSPOSE « Lookup Reference functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Lookup Reference functions
  3. TRANSPOSE
Input the formula: =TRANSPOSE($A$2:$C$2). 
       And Select A7, A8, A9.
Input the formula: =TRANSPOSE($A$2:$C$2)
Press Shift+Control+Enter to get the result.
Input the formula: =TRANSPOSE($A$2:$C$2)
19.14.TRANSPOSE
19.14.1.TRANSPOSE(array) returns the transpose of an arrayTRANSPOSE(array) returns the transpose of an array