Transposing Data is when you reorient your data from Vertical to Horizontal, and vice versa. I will show you how to do so in Google Sheets. It is a super quick and easy function that provides you with an interactive and dynamic transposed data table.
=TRANSPOSE()
You can transpose data with this function, =TRANSPOSE(). Within the parentheses, you will post the range that you wish to transpose, which is easier if you name that cell range.
When you hit enter, the data cell will be reposted in a transposed fashion.
As you can see, the data table has been transposed from a vertical data table to a horizontal data table.
Also, keep in mind that you will not be able to directly edit the cells within the transposed table. Rather, you will need to edit the original cell range to edit the transposed cell range.
And there you have it; that is how you transpose cell ranges in Google Sheets.