Google Sheets Function: TRANSPOSE

The TRANSPOSE function returns a range by swapping rows and columns (rows become columns and vice versa).

Usage:

=TRANSPOSE(array_or_range)


Example of use

To swap the rows and columns of the following range:

google sheets range transpose

Simply enter the range of cells into the TRANSPOSE function:

=TRANSPOSE(A1:B7)
google sheets function transpose