Skip to Content

TRANSPOSE

Returns the transpose of an array

Syntax

TRANSPOSE(array)

Parameters

  • array: Required. An array or range of cells on a worksheet that you want to transpose

Example

=TRANSPOSE(A1:B5)
Returns: ArraySince: Excel 2003