Excel Function : TRANSPOSE

Download now!

Excel Function : TRANSPOSE

Category

Lookup and reference

Description

Returns the transpose of an array

Microsoft Excel Reference Page

https://support.office.com/en-us/article/TRANSPOSE-function-ed039415-ed8a-4a81-93e9-4b6dfac76027

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.