Two Ways on How to Transpose in Google Sheets

transposing in google sheets

There’s a time when you need to turn a vertical range of cells into a horizontal one or vice versa, which is called transposing. Here’s how to transpose in Google Sheets in different ways.

Transposing is useful when you have a vertical range of cells (the row header is at the top and its content follows in the next row) but you want to make it horizontal, so the row header would be on the left side and its content follows in the next column.

The methods themselves can be done quickly, and each provides a different purpose.

How to transpose with a function in Google Sheets

You can also transpose with a function. It works by using a formula that gathers the original data and turns it into the transposed one.

If you want to make changes to the original data that would affect the transposed data, you can use this function. If you remove the original data, the transposed one will be lost as well.

=TRANSPOSE(the range of cells to transpose)

Simply type the formula in an empty area that is enough to fit the entire transposed data, and select the range of cells to transpose. If it isn’t enough, it will return an error message.

transpose using a formula

How to transpose in Google Sheets using the paste feature

If you get a range of cells that you want to turn into a vertical or horizontal, you can do that quickly with the paste transposed feature.

This feature works by copying the original data and paste it somewhere else (on any area of your sheet, a new empty sheet, etc).

The transposed result will work as independent data just like the original, so you can either delete the original replacing it with the transposed result, or make changes to the original data without affecting the transposed result.

To do this, simply select the entire dataset. Do this by selecting one of the cells, then press CTRL+A.

how to transpose in google sheets

You can either press CTRL+C or right-click and select Copy to copy the entire dataset.

copying a data in google sheets

Find a new empty area of your sheet, right-click at the cell which will be the first cell of transposed data (the first cell is the top-left of the data).

Right-click, and select Paste special. Select Paste transposed.

paste special paste transposed

Once you have pasted, you can immediately see the transposed data.

transposing in google sheets


Transposing is really useful to see your data from a different perspective, for example, to see the entire data horizontally (from left to right) instead of vertically (from the top to bottom), and Google Sheets provides you two ways to do that.

Leave a Comment

Your email address will not be published. Required fields are marked *