Skip to main content

How to transpose rows and columns of table in Word?

Author: Sun Last Modified: 2024-07-04

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 table in Word with Paste Special

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


Transpose rows and columns of table in Word with Paste Special

1. Click the cross button to select and then copy the table in Word. See screenshot:

doc transpose rows columns 1

2. Open an Excel worksheet, and paste the table into the worksheet.

3. Select and copy the table in Excel. Right-click on a blank cell, and then click Paste Special > Transpose(T) from the context menu. See screenshot:

doc transpose rows columns 2

4. After transposing, if some of the borders of the table disappeared, you can select the table and click Home > All Borders under the Borders drop-down list. See screenshot:

doc transpose rows columns 3

5. Select and copy the transposed table and paste it to the Word document. You can see the differences after transposing as follows:

doc transpose rows columns 4


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

If you have Kutools for Word, with its Transpose Table feature, you can convert columns and rows in a table with only one click.

Kutools for Word, equipped with AI πŸ€–, offers over 100 handy features to simplify your tasks.

After installing Kutools for Word, please do as this:

1. Select the table that you want to transpose, and then, click Kutools Plus > Transpose Table, see screenshot:

doc transpose rows columns 5

2. And then, a prompt box is popped out:

(1.) If you want to replace the original table with the new transposed one, please click the Yes button;

(2.) If you want to put the new transposed table to another place, please click the No button.

doc transpose rows columns 6

3. In this example, I will click the No button, and the new transposed table will be inserted into the Word file, see screenshot:

doc transpose rows columns 7

Click to download Kutools for Word and start free trial now!

Best Office Productivity Tools

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

πŸ€– Kutools AI Assistant: Transform your writing with AI - Generate Content  /  Rewrite Text  /  Summarize Documents  /  Get Quick Answers, all within Word

πŸ“˜ Document Mastery: Split Pages  /  Merge Documents  /  Export Selection in Various Formats (PDF/TXT/DOC/HTML...)  /  Batch Convert to PDF  /  Export Pages as Images  /  Print Multiple Files at once...

✏ 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  /  All Headers  /  Text Boxes  /  Hyperlinks  /  For more removing tools, head to the Remove group...

βž• Creative Inserts: Insert Thousand Separators  /  Check Boxes  /  Radio Buttons  /  QR Code  /  Barcode  /  Diagonal Line Table  /  Equation Caption  /  Image Caption  /  Table Caption  /  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...

πŸ‘‰ Want to try these features? Download Kutools for Word now! πŸš€
 
Comments (0)
No ratings yet. Be the first to rate!
There are no comments posted here yet
Leave your comments
Posting as Guest
Rate this post:
0   Characters
Suggested Locations