Convert rows to columns & columns to rows in Google Sheets – transpose

Use Google Sheets menus to transpose rows to columns & vice versa

1. Select the data you want to transpose in Google Sheets (I mean, switch rows and columns) and copy it to the clipboard.

   Note. Make sure to select headers as well.

   Tip. You can copy the data by pressing Ctrl+C on your keyboard or using the related option from the context menu:

2. Create a new sheet (or pick any other place for your future new table) and select its leftmost cell.
3. Right-click that leftmost cell and choose Paste special > Transposed from the context menu:

The range you copied will be inserted but you'll see that Google Sheets transposed columns into rows:

Google Sheets TRANSPOSE function

You won't be surprised if I tell you there's a Google Sheets function specifically for this purpose, will you? It's called TRANSPOSE and it takes just the data you need to convert :)

Here, I put the cursor into a cell where my future table will start — A9 — and enter the following formula there:

=TRANSPOSE(A1:E7)

A1:E7 is a range with my original table. 

A9 — the cell with the Google Sheets TRANSPOSE — becomes the leftmost cell of my new table where rows and columns switch places:

The main advantage of this method is that once you alter the data in your original table, the values will change in the transposed table as well.

The first method, on the other hand, kind of creates a "photo" of the original table in its one state.