Table of Contents
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.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)