WD: How to Transpose Rows and Columns in Word Table

ID: Q143321

The information in this article applies to:

SUMMARY

Word does not have the ability to transpose cells in a table; that is, you cannot use Word to switch the orientation of columns to rows or vice versa. This article describes how to use Microsoft Excel to provide this functionality.

MORE INFORMATION

To transpose the rows and columns of your table, do the following:

 1. Open your Word document, select the table, and then click Copy on the
    Edit menu.

 2. Start Excel.

 3. In Excel, click Paste Special on the Edit menu, click Paste,
    select Text, and then click OK.

 4. Select the cells that contain the data that you want to transpose.

 5. On the Edit menu, click Copy.

 6. Select the upper-left cell of the paste area. Choose a blank area
    of your Excel worksheet.

 7. On the Edit menu, click Paste Special.

 8. Select the Transpose check box, and then click OK.

    This action switches the orientation of data when you paste it. For
    example, data from the top row of the copied area appears in the
    left column of the paste area; data from the left column appears in
    the top row.

    NOTE: If you get a Selection Not Valid error at this point, your
    paste area contains data. Make sure you select a blank area on your
    worksheet.

 9. Select the cells with the transposed data and click Copy on the Edit
    menu.

10. Switch to Word. Place your insertion point where you want to paste
    the table.

11. Click Paste Special on the Edit menu, choose Paste, select Formatted
    Text (RTF), and then click OK.

MORE INFORMATION

Before you use the Transpose command, consider the following:

Additional query words: transpose transposing transposes rotates pivots moves columns rows position
Keywords          : wordnt macword98 winword ntword macword kbtable word7 word95 
Version           : WINDOWS: 6.0, 7.0; MACINTOSH: 6.0, 6.0.1, 98
Platform          : MACINTOSH WINDOWS
Issue type        : kbhowto

Last Reviewed: January 22, 1999