When analyzing data in Google Sheets, you may realize that your spreadsheet is formatted incorrectly for your needs. Perhaps you have a long list of months running down a single column, but you actually need them spread horizontally across the top row to act as headers.
Manually retyping or dragging each individual cell to a new location is tedious and prone to errors. Fortunately, you can instantly flip data from vertical to horizontal (or vice versa) using a process called transposing.
In this guide, you will learn two different ways to transpose data in Google Sheets: using the standard Paste Special menu for static data, and using the TRANSPOSE function for dynamic, automatically updating data.
Method 1: Using Paste Special (Best for Static Data)
If you simply want to flip your data once and do not need it to remain linked to the original cells, the Paste Special tool is the fastest method.
- Highlight all the data you want to transpose (e.g., a vertical column of names).
- Copy the data by pressing Ctrl + C (Windows) or Cmd + C (Mac).
- Click on a completely empty cell where you want the new horizontal data to begin. (Ensure there is enough empty space to the right of the cell, or you will overwrite existing data).
- Right-click the empty cell.
- In the menu that appears, hover your mouse over Paste special.
- From the sub-menu, select Transposed.
Your vertical list will instantly paste as a horizontal row. You can now delete the original vertical column if you no longer need it.
Method 2: Using the TRANSPOSE Function (Best for Live Data)
If your original data is constantly changing, and you want the transposed version to update automatically whenever the original data is edited, you must use a formula.
- Click on an empty cell where you want the transposed data to begin.
- Type the following formula:
=TRANSPOSE( - Use your mouse to highlight the original range of data you want to flip (for example, A1 to A10). Your formula will now look like:
=TRANSPOSE(A1:A10) - Press Enter.
Google Sheets will automatically populate the neighboring cells with the flipped data. Because this data is powered by a formula, if you change a value in the original A1 cell, the transposed version will instantly reflect that change.
Formatting Data Efficiently
Whether you need to quickly reorient a table for a presentation using Paste Special, or build a dynamic dashboard using the formula, knowing how to transpose data in Google Sheets allows you to completely restructure your spreadsheets in seconds without retyping a single word.