TRANSPOSE Function

About

TRANSPOSE function returns the transpose of an array. i.e. TRANSPOSE function returns the vertical range as a horizontal range and a horizontal range as a vertical range. TRANSPOSE function should be entered as array formula.

Function Type

Lookup and reference

Purpose

Switch the rows and columns of an array

Return value

Transpose of the given array

Syntax

=TRANSPOSE(array)

Arguments

array – The array or range of cells to transpose.


Example 1


Notes

In the versions of Excel other than Office 365, TRANSPOSE function should be entered as an Array formula using Ctrl + Shift + Enter keys.


Read about Excel Functions

Excel Functions in Alphabetical Order (Complete list)

Complete List of Excel Functions (Category wise)


New Dynamic Array Functions in Excel

LET Function in Excel

STOCKHISTORY Function in Excel