TRANSPOSE function

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

Sample usage

TRANSPOSE({1,2;3,4;5,6})

TRANSPOSE(A2:F9)

Syntax

TRANSPOSE(array_or_range)

  • array_or_range – The array or range whose rows and columns will be swapped.

Notes

  • Transposition operates such that the value in the nth row and mth column will become the value in the mth row and nth column. E.g. the value in the fourth row and second column will be put into the second row and fourth column. The result of a transposition on a range of size m rows by n columns is therefore n rows by m columns.

Examples

Was this helpful?
How can we improve it?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Centre
true
35
false