How to Rotate a Table in Excel: 3 Easy Ways

How-to basics · Updated November 22, 2026

To rotate a table in Excel, meaning to turn its rows into columns and columns into rows, use the Transpose feature. The quickest method is to copy the table, right-click the destination cell, and choose Paste Special > Transpose. For a dynamic version that updates automatically when the original changes, use the TRANSPOSE function as an array formula.

What “Rotating” a Table Actually Means

In Excel, “rotating” a table almost always means transposing it: swapping the orientation so that data in rows moves to columns and data in columns moves to rows. For example, if your table lists months in column A and sales figures across row 1, transposing would put months across row 1 and sales figures down column A. This is different from rotating a chart, which spins a 3-D chart or changes its angle, or rotating text within cells. When people search for “rotate table,” they usually want to reorganize their data layout without retyping everything.

Method 1: Paste Special (Static Transpose)

This is the simplest and most common approach. It creates a static copy—if you change the original data, the transposed copy will not update. Here’s how to do it in Excel for Microsoft 365 on Windows:

  1. Select the entire table (including headers) and press Ctrl+C to copy.
  2. Click on the cell where you want the top-left corner of the rotated table to appear. Make sure it’s empty—the transposed data will overwrite anything there.
  3. Right-click the destination cell, then under Paste Options, select Transpose (it looks like a small table with arrows). Alternatively, go to Home > Paste > Transpose.

On a Mac, the shortcut is Cmd+C to copy, and after right-clicking, you’ll see the same Transpose icon. If you don’t see it, go to Edit > Paste Special > Transpose.

One common mistake: if you select the destination cell and paste, Excel may overwrite existing data without warning. Always double-check that the destination area is clear. Also, transposing a large table (thousands of rows) can be slow, but it works fine for typical datasets.

Method 2: The TRANSPOSE Function (Dynamic)

If you want the rotated table to automatically reflect changes in the original, use the TRANSPOSE function. This is an array formula, which means it must be entered with a special key combination. Here’s the step-by-step for Excel 365 and Excel 2021:

  1. Select the range where you want the transposed data to appear. It must have the same number of rows as the original has columns, and the same number of columns as the original has rows. For example, if your original table is 5 rows by 3 columns, select a range that is 3 rows by 5 columns.
  2. Type =TRANSPOSE( and then select the original table range. If your original is A1:C5, type =TRANSPOSE(A1:C5).
  3. Press Ctrl+Shift+Enter (on Mac: Cmd+Shift+Enter) to enter it as an array formula. In Excel 365, you can also just press Enter because dynamic arrays are native, but Ctrl+Shift+Enter still works.

The result is a live link: if you edit any cell in the original table, the transposed version updates instantly. A limitation is that you cannot delete individual cells in the transposed range—you must clear the entire array. Also, if the original table changes size (rows or columns added), the transposed range won’t automatically expand; you’d need to adjust the formula range.

Method 3: Power Query (For Complex Rotations)

Power Query is a more advanced tool that handles larger datasets and more complex transformations, like unpivoting or rotating multiple tables at once. To transpose with Power Query:

  1. Select your table and go to Data > From Table/Range (this opens the Power Query editor).
  2. In the Power Query editor, go to the Transform tab and click Transpose.
  3. Click Close & Load to bring the rotated data back into a new worksheet.

This method creates a query that you can refresh if the source data changes. It’s particularly useful when you need to rotate a table that is regularly updated, or when you want to combine transposition with other data-cleaning steps. However, it has a steeper learning curve and is overkill for a simple one-off rotation.

How to Choose the Right Method

Your choice depends on your needs:

  • Static paste – Use when you need a one-time rotated copy and don’t care about updates. It’s the fastest and simplest.
  • TRANSPOSE function – Use when you want the rotated table to stay in sync with the original. Ideal for dashboards or reports where source data changes frequently.
  • Power Query – Use when you have a large dataset, need to refresh automatically, or want to perform additional transformations (like filtering or merging) alongside the rotation.

If you’re working with a formatted table (created via Insert > Table), note that paste transpose will lose the table formatting and convert it to a normal range. The TRANSPOSE function also returns a plain range, not a formatted table. To keep formatting, you may need to reapply borders and styles after rotating.

Common Problems and How to Fix Them

Here are frequent issues users encounter:

  • “The TRANSPOSE function returns #VALUE!” – This usually happens when the destination range is not exactly the right size. Count the rows and columns of your original, then select the transposed dimensions before entering the formula.
  • “Paste Special doesn’t show Transpose” – Make sure you copied a range (not a single cell) and that the destination is not within the copied range. In some versions, you need to use the right-click menu, not the Home tab, to see all paste options.
  • “My transposed data is cut off” – If you used Paste Special and only part of the table appears, you likely selected only a few cells as the destination. The paste operation fills the entire transposed range, but if you had selected a smaller area, it may clip. Always select just the top-left cell for paste special.
  • “I can’t edit the transposed cells” – If you used the TRANSPOSE function, the entire range is an array. You can’t edit individual cells. If you need to edit, use Paste Special instead, or convert the array to values (copy, paste as values).

Another misconception: rotating a table does not change the original data. The original remains untouched; you’re creating a separate copy or a linked view. If you want to permanently replace the original with the rotated version, you’ll need to delete the original after transposing.

Frequently Asked Questions

How do I rotate a table 90 degrees in Excel?

Rotating a table 90 degrees is the same as transposing it. Use the Paste Special > Transpose method or the TRANSPOSE function. There is no built-in feature to rotate a table by an arbitrary angle; transposition is the only standard way to change orientation.

Can I rotate a table in Excel without copying and pasting?

Yes, you can use the TRANSPOSE function, which creates a dynamic reference without copy-pasting. You still need to select the destination range and enter the formula, but you don’t have to copy the original data. Power Query is another no-copy option.

Why is my TRANSPOSE function not working?

The most common reason is that you didn’t press Ctrl+Shift+Enter (or Cmd+Shift+Enter on Mac) to enter it as an array formula. In Excel 365, pressing Enter usually works, but if you’re on an older version, you must use the array key combination. Also, check that the destination range has the correct number of rows and columns.

How do I rotate a table in Excel on a Mac?

The steps are the same: copy the table, right-click the destination, and choose Transpose from the Paste Options. For the TRANSPOSE function, use Cmd+Shift+Enter to enter the array formula. Power Query is also available on Mac in Excel 365.

Does rotating a table affect charts or formulas that reference it?

If you use Paste Special, the rotated copy is independent, so charts and formulas that reference the original continue to work. If you use the TRANSPOSE function, the rotated range is a reference to the original, so any changes to the original will reflect in the rotated version, but charts that point to the original are unaffected. If you delete the original after transposing, any formulas that referenced the original will break.

Can I rotate a table with merged cells?

Transposing a range with merged cells can cause issues. Excel may paste the merged cells as unmerged, or it may refuse to transpose if the merged cells span multiple rows/columns. It’s best to unmerge cells before transposing, then reapply merging if needed.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.