TRANSPOSE Function in Google Sheets

Switch the rows and columns of an array or range using the TRANSPOSE function.

TRANSPOSE Function

The TRANSPOSE function in Google Sheets switches the rows and columns of an array or range.

Syntax

TRANSPOSE(array_or_range)
  • array_or_range: The array or range to transpose.

Examples

  1. Basic Transposition

Transpose the array in A1:C3:

=TRANSPOSE(A1:C3)
  1. Larger Array

Transpose the range D1:F5:

=TRANSPOSE(D1:F5)

Notes

  • Useful for reformatting data, especially when the original layout is not suitable for analysis.
  • TOCOL: Convert an array or range into a single column.
  • TOROW: Convert an array or range into a single row.