Skip to main content

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

Author: Sun Last Modified: 2018-12-17

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

Recommended Productivity Tools for Word

Kutools for Word: Integrating AI 🤖, over 100 advanced features save 50% of your document handling time.Free Download

Office Tab: Introduces the browser-like tabs to Word (and other Office tools), simplifying multi-document navigation.Free Download


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.



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  /  Polish Text for Clarity  /  Summarize Documents  /  Inquire for Information based on Document, 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 our 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 swiftly to any location  /  auto-insert repetitive text  /  seamlessly toggle between document windows  /  11 Conversion Tools...

👉 Want to try these features? Kutools for Word offers a 60-day free trial, with no limitations! 🚀
Free Download     Read More     Buy 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