TRANSPOSE

Switches rows and columns from ranges or {data} and creates a table with the results.

Parameter List

Syntax
TRANSPOSE(data)
data

The range or {data} to be transposed. For example: A1:B10.

Examples

TRANSPOSE(A1:B3) returns expands and overwrites the content of the transposed table.