The Transpose function transposes the rows and columns of an array. For example, with the following values:

A formula =Transpose(Sheet1.A1:C2) gives this result:

The Transpose function works with any array, table range, vector, or matrix.

---

Function

Transpose(array) array

---