Skip to main content

Kutools for Office — One Suite. Five Tools. Get More Done.

How to transpose rows and columns of table in Word?

Author Sun Last modified

There may be times when you need to switch the orientation of your table in Microsoft Word, transposing rows into columns and columns into rows. This can be particularly useful for reformatting data to improve readability or to meet specific document requirements.

In this tutorial, we will show you how to transpose rows and columns of a table in Word, providing you with a step-by-step guide to rearrange your data quickly and efficiently.

Transpose rows and columns of a table in Word with Paste Special

Transpose rows and columns of a table in Word with Kutools for Word

Transpose rows and columns of a table in Word with Paste Special

Follow these steps to transpose rows and columns of a table in Word:

  1. Select the table by clicking the table selection button, then press Ctrl + C to copy it in Word.

    The table is selected

  2. Open an Excel worksheet, and paste the table into the worksheet using the shortcut keys Ctrl + V.
  3. In Excel, use the shortcut key Ctrl + C to copy the table again. Right-click on a blank cell, then choose Paste Special > Transpose(T) from the context menu.

    Paste Special > Transpose(T) option on the context menu

  4. If some borders disappear after transposing, select the table and go to Home > All Borders from the Borders dropdown.

    All Borders option on the ribbon

  5. Copy the transposed table from Excel, then paste it back into the Word document. You can observe the changes after transposing as shown below:

    Transposed table copied and pasted into the Word document

Transpose rows and columns of a table in Word with Kutools for Word

If you have Kutools for Word, its Transpose Table feature allows you to convert columns and rows in a table with just one click directly in Word.

Kutools for Word, equipped with AI 🤖, offers over 100 handy features to simplify your tasks.

After installing Kutools for Word, follow these steps:

  1. Select the table that you want to transpose, then click Kutools Plus > Table > Transpose Table.
    Transpose Table option on the Kutools Plus tab on the ribbon
  2. A prompt box saying "Do you want to cover the original table with the transpose one?" will appear:
    • If you want to replace the original table with the new transposed one, click Yes.
    • If you want to insert the new transposed table below the original one, click No.
    Dialog box asking 'Do you want to cover the original table with the transposed one?'
  3. In this example, I will click the No button, and the new transposed table will be inserted into the Word file.
    Transposed table copied and pasted into the Word document

Best Office Productivity Tools

Kutools for Word - Elevate Your Word Experience with Over 100 Remarkable Features!

🤖 Kutools AI Features: AI Assistant / Real-Time Assistant / Super Polish (Preserve Format) / Super Translate (Preserve Format) / AI Redaction / AI Proofread...

📘 Document Mastery: Split Pages / Merge Documents / Export Selection in Various Formats (PDF/TXT/DOC/HTML...) / Batch Convert to PDF...

✏ Contents Editing: Batch Find and Replace across Multiple Files / Resize All Pictures / Transpose Table Rows and Columns / Convert Table to Text...

🧹 Effortless Clean: Sweap away Extra Spaces / Section Breaks / Text Boxes / Hyperlinks / For more removing tools, head to the Remove group...

➕ Creative Inserts: Insert Thousand Separators / Check Boxes / Radio Buttons / QR Code / Barcode / Multiple Pictures / Discover more in the Insert group...

🔍 Precision Selections: Pinpoint Specific Pages / Tables / Shapes / Heading Paragraphs / Enhance navigation with more Select features...

⭐ Star Enhancements: Navigate to Any Location / Auto-Insert Repetitive Text / Toggle Between Document Windows / 11 Conversion Tools...

🌍 Supports 40+ Languages: Use Kutools in your preferred language – supports English, Spanish, German, French, Chinese, and 40+ others!

Kutools and Kutools Plus tabs on the Word Ribbon
👉 Want to try these features? Download Kutools for Word now! 🚀
 

✨ Kutools for Office – One Installation, Five Powerful Tools!

Includes Office Tab Pro · Kutools for Excel · Kutools for Outlook · Kutools for Word · Kutools for PowerPoint

📦 Get all 5 tools in one suite | 🔗 Seamless integration with Microsoft Office | ⚡ Save time and boost productivity instantly

Best Office Productivity Tools

Kutools for Word - 100+ Tools for Word

Free Download Buy Now Learn More about Kutools