Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Lookup and Reference > TRANSPOSE
 

TRANSPOSE(array)

 
 Returns an array of values with its orientation changed.

 arrayThe array or range of cells that you want to transpose.

 REMARKS
 
  		• This function can return an array.
     
  		• This function can be used to shift the vertical and horizontal orientation of an array or cell range on a worksheet.
     
  		• This must be entered as an array formula using (Ctrl + Shift + Enter).
     
  		• You must also highlight a range of cells which has the same number of rows and columns, respectively as the "array" argument.
     
  		• For a working example please refer to the Matrix Functions page.

     EXAMPLES
     
     A
    1=TRANSPOSE(1) = 1
    2={TRANSPOSE({1,2,3,4}) } = { {1}, {2}, {3}, {4} }
    3={TRANSPOSE({{1}, {2}, {3}, {4}}) } = {1,2,3,4}
    		 
     Functions - T | Index - T | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top