How to transpose rows and columns of table in Word?
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:
- Select the table by clicking the table selection button, then press Ctrl + C to copy it in Word.
- Open an Excel worksheet, and paste the table into the worksheet using the shortcut keys Ctrl + V.
- 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.
- If some borders disappear after transposing, select the table and go to Home > All Borders from the Borders dropdown.
- Copy the transposed table from Excel, then paste it back into the Word document. You can observe the changes after transposing as shown below:
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.
After installing Kutools for Word, follow these steps:
- Select the table that you want to transpose, then click Kutools Plus > Table > Transpose Table.
- 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.
- In this example, I will click the No button, and the new transposed table will be inserted into the Word file.
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!
Best Office Productivity Tools
Kutools for Word - 100+ Tools for Word
- 🤖 Kutools AI Features: AI Assistant / Real-Time Assistant / Super Polish / Super Translate / AI Redaction / AI Proofread
- 📘 Document Mastery: Split Pages / Merge Documents / Batch Convert to PDF
- ✏ Contents Editing: Batch Find and Replace / Resize All Pictures
- 🧹 Effortless Clean: Remove Extra Spaces / Remove Section Breaks
- ➕ Creative Inserts: Insert Thousand Separators / Insert Check Boxes / Create QR Codes
- 🌍 Supports 40+ Languages: Kutools speaks your language – 40+ languages supported!