Excel Function : TRANSPOSE

Download now!

Excel Function : TRANSPOSE


Lookup and reference


Returns the transpose of an array

Microsoft Excel Reference Page


Syntax and Description of the TRANSPOSE Excel Function

TRANSPOSE(array) The TRANSPOSE function returns a transposed version of the input array. The input array must be a rectangular array.

About TRANSPOSE Excel Function

TRANSPOSE is an Excel function that allows you to rotate the data in a range or array so that the columns become the rows, and the rows become the columns. This can be useful when you want to rearrange data in a certain order, or when you want to compare data side by side.