How to Transpose Data (Switch Rows and Columns) in Google Sheets

When you are building a complex spreadsheet in Google Sheets, you may suddenly realize that your data is oriented incorrectly. Perhaps you typed your months across the top row (as columns) but now realize you need them listed down the left side (as rows) to generate a specific chart or integrate with a new formula. Manually copying and pasting each individual cell to rearrange the grid is tedious and prone to human error. Instead, Google Sheets includes a powerful “Transpose” feature that instantly flips your data, turning rows into columns and columns into rows.

How to Transpose Data Using Paste Special

The fastest way to permanently rotate a static block of data is to use the Paste Special menu.

1. Click and drag your mouse to highlight the entire block of data you want to rotate, including the headers.
2. Copy the data by pressing Ctrl + C (Windows/ChromeOS) or Command + C (Mac). A dotted blue line will appear around your selection.
3. Click on a single, empty cell in a completely blank area of your spreadsheet. This cell will become the new top-left corner of your rotated data. Important: Do not paste over your existing data, as they will overlap and corrupt the grid.
4. Right-click on that new empty cell.
5. Hover your mouse over Paste special in the context menu.
6. From the sub-menu that appears, select Transposed.

Google Sheets will instantly paste your data, flipping the X and Y axes perfectly. Your original data remains intact in its original location; once you verify the transposed data looks correct, you can safely highlight and delete the original block.

How to Transpose Data Using a Live Formula

The Paste Special method is excellent for a one-time fix, but the new data is completely disconnected from the original. If you are building a dashboard and you want the transposed data to update automatically whenever someone edits the original grid, you must use the TRANSPOSE function instead.

1. Click on a blank cell where you want the top-left corner of your new rotated grid to start.
2. Type the following formula, replacing A1:E5 with the actual range of your original data:

   =TRANSPOSE(A1:E5)

3. Press Enter.

The entire grid will instantly generate itself dynamically. Because this is a live array formula, you cannot edit individual cells inside the new transposed grid. If you need to fix a typo or update a number, you must make the change in the original source data (A1:E5), and the transposed view will automatically reflect the change in real-time.