Google Sheets Function: TRANSPOSE

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



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:

google sheets function transpose