Tip: Other languages are Google-Translated. You can visit the version of this link.
Log in
x
or
x
x
Register
x

or

Quickly transpose data in rows and columns of a table in Word

If you need to transpose data from rows to columns or vice versa, you need to copy the table to Excel worksheet and use the paste special function to transpose the table, then paste the transposed table back to Word. Here, I introduce a handy add-in tool – Kutools for Word, its Transpose Table utility can handle this job with two clicks.


Applying Transpose Table by clicking Kutools Plus > Transpose Table.
shot transpose table 1

Kutools for Word: Add 100 New Advanced Features to Word 2003 / 2007 / 2010 / 2013 / 2016 / 2019.
Office Tab: Enable Tabbed Editing and Browsing in Office, Just Like Chrome, Firefox, IE 8/9/10.
Classic Menu for Office: Bring Old Look of Office 2003 Back to Office 2007, 2010, 2013, 2016 and 2019.

Transpose data in rows and columns of a table

1. Place cursor at the table you want to transpose data from rows to columns, click Kutools Plus > Transpose Table.
shot transpose table 2

2. A Kutools for Word dialog pops out:

Click Yes, the original table will be covered directly with the transposed one;

Click No, the transposed table will be created below the original one;
shot transpose table 3

Then rows and columns in the selected table has been transposed.
shot transpose table 4

Notes:

1. This feature works at one table once.

2. This feature will keep the table formatting after transposition.



 

This is only one tool of Kutools for Word

li-orangeKutools for Word frees you from performing time-consuming operations in Word;

li-orangeWith bundles of handy tools for Word 2019, 2016, 2013, 2010, 2007, 2003 and Office 365;

li-orangeEasy to use and install in Windows XP, Windows 7, Windows 8 / 10 and Windows Vista;

More Features  |  Free download  |  Buy now

Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.