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.
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.
You can either press CTRL+C or right-click and select Copy to copy the entire dataset.
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.
Once you have pasted, you can immediately see the transposed data.
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.
Dony Prasetiyo has been writing on monkeymanifesto.com for about two years, intended to help solve computer and smartphone problems with easy-to-understand blog posts. He has written over 480 blog posts about Windows, Office, Android, and more.