Word Transpose Table: How to Swap Rows and Columns

A word transpose table is a way to flip a table’s orientation in Microsoft Word, turning rows into columns and columns into rows. You can do this by copying the table, pasting it as plain text, using Excel to transpose it, and then pasting it back into Word.

Formula

The transpose operation itself has no mathematical formula—it is a rearrangement of data. However, when you transpose a table that contains numbers, the values stay the same; only their positions change. For example, if cell A1 holds 10 and cell B1 holds 20, after transposing, cell A1 still holds 10 and cell B1 still holds 20, but they now appear in a different row/column arrangement.

If you are transposing a table that includes computed values (like averages or totals), those formulas must be recalculated after the transpose because the cell references change. In Word, formulas in tables use cell references like A1, B2, etc. After transposing, a formula that referenced A1 might now need to reference B1, depending on the new layout.

Worked Example

Suppose you have a Word table with sales data for two quarters:

• Row 1: Q1, Q2
• Row 2: 100, 150

You want to transpose it so that the quarters become columns and the sales numbers become rows. The result would be:

• Row 1: Q1, 100
• Row 2: Q2, 150

To do this in Word, you copy the table, paste it into Excel, use the Transpose feature (copy, right-click, Paste Special, check Transpose), then copy the transposed data and paste it back into Word as a new table.

Why Transpose a Table in Word?

You might need to transpose a table to better fit the page layout, to match a required format for a report, or to make data easier to compare. For example, a table with many columns might be too wide for a portrait page; transposing it makes it longer but narrower, so it fits better. Also, some charts or graphs in Word or Excel require data in a specific orientation—transposing can help prepare the data correctly.

Another common reason is when you receive a table from a colleague or a data export that is in the wrong orientation. Instead of manually retyping every cell, transposing saves time and reduces errors.

How to Transpose a Table in Word (Step-by-Step)

There is no one-click transpose button in Word, but the following method works reliably across Word 2016, 2019, 2021, and Microsoft 365.

1. Select the entire table in Word by clicking the small square icon that appears at the top-left corner of the table when you hover over it.
2. Copy the table (Ctrl+C or Cmd+C).
3. Open Microsoft Excel (or Google Sheets if you prefer).
4. Click on a blank cell where you want the transposed data to start.
5. Right-click and choose Paste Special (in Excel, it’s under Paste Options).
6. In the Paste Special dialog, check the “Transpose” box at the bottom right.
7. Click OK. The data now appears with rows and columns swapped.
8. Copy the transposed data in Excel.
9. Go back to Word and place your cursor where you want the new table.
10. Paste (Ctrl+V or Cmd+V). Word will create a new table with the transposed data.

If you don’t have Excel, you can use Google Sheets or any spreadsheet app that has a transpose paste option. You can also manually create a new table and type the data, but that is error-prone for large tables.

Common Mistakes and Pitfalls

One common mistake is forgetting that pasting a table into Word as plain text loses the table borders and formatting. To keep the table structure, paste it as a table (use “Keep Source Formatting” or “Merge Formatting” in the paste options).

Another issue: if your table contains merged cells, transposing can break the layout. Word’s transpose method via Excel does not handle merged cells well—it may unmerge them or produce unexpected results. It’s best to unmerge all cells before transposing.

Also, if your table has formulas (e.g., a total row), those formulas will not transpose correctly. After transposing, you must manually update the formulas to reference the new cell positions.

Finally, be aware that very large tables (thousands of rows) might slow down Excel or Word, but for typical tables this method works fine.

Alternatives to Transposing in Word

If you don’t want to use Excel, there are a few other ways to transpose a table in Word:

• Manual retyping: For small tables, you can simply create a new table and type the data in the swapped orientation. This is quick but error-prone for large tables.
• Use a macro: You can record a macro in Word that automates the transpose process, but writing a VBA macro requires some programming knowledge.
• Online converters: Some websites allow you to paste tabular data and transpose it, but be cautious about uploading sensitive data to third-party sites.
• Convert to text and back: You can convert the table to text (Layout tab > Data > Convert to Text), then use a text editor to rearrange the data, then convert back to a table. This is tedious and not recommended for large tables.

For most users, the Excel paste-special method is the simplest and most reliable.

Frequently Asked Questions

Can I transpose a table directly in Word without Excel?

No, Word does not have a built-in transpose feature. You must use an external tool like Excel or Google Sheets, or manually recreate the table. Some third-party add-ins might offer this feature, but they are not part of standard Word.

Will transposing a table affect its formatting?

Yes, the formatting (borders, shading, fonts) is not preserved when you paste through Excel. You will need to reapply formatting after transposing. To minimize this, use the “Keep Source Formatting” paste option when pasting back into Word, but even then, column widths and row heights may change.

How do I transpose a table with merged cells?

Merged cells are problematic. You should unmerge all cells before transposing. In Word, select the table, go to Layout > Merge Cells to unmerge. Then follow the transpose steps. After transposing, you may need to re-merge cells as needed.

Does transposing work with tables that contain images or other objects?

It can work, but images and objects may not transpose correctly. They might be placed in the wrong cells or lose their size. It’s best to remove images before transposing and reinsert them afterward.

Is there a way to transpose a table in Google Docs?

Google Docs also lacks a direct transpose feature. You can copy the table, paste it into Google Sheets, use the TRANSPOSE function, and then copy back. Alternatively, you can use the same Excel method if you have access to Excel.

Why does my pasted table lose its borders?

When you paste from Excel into Word, the table borders may not be visible because Excel’s gridlines are not the same as Word’s table borders. To fix this, select the pasted table, go to Table Design > Borders, and apply the desired border style.

Related

• Clover Time Traits Tier List: Keep or Reroll?
• Best Free Deputy Alternatives for Small Teams
• Claude Prompt Caching in Node.js: Cut Repeat Costs

in t | Time (minutes) | min | 30 | 0
in d | Distance (km) | km | 5 | 0
out pace | Average pace | min/km | t / d | 2
out speed | Average speed | km/h | d / (t / 60) | 2