Transpose function

Description

This TRANSPOSE function convert the orientation of a given range or array. TRANSPOSE converts a vertical range to a horizontal range, or a horizontal range to a vertical range. TRANSPOSE function has to be used as array formula.

​

Objective

Convert the orientation of a range cells.

​

Syntax

=TRANSPOSE(array)

​

Arguements

array - Array or range of cells to transpose.

​

​

​