Transpose formula

Transposes the rows and columns of an array or range of cells.

How to use?

SYNTAX: =TRANSPOSE(array_or_range)
array_or_range - The array or range for which the rows and columns will be swapped.

PRACTICE SHEET

The above sheet is view only mode, please make a copy to practice.

Copy of Transpose

Make A Copy

Page updated

Google Sites

Report abuse