Swapping rows and columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Susan Eisen - 11 Aug 2003 21:45 GMT

Is there a quick (and I do mean quick) and dirty way to
convert my rows to columns and my columns to rows?
Thanks,
--Susan

Reply to this Message

Suzanne S. Barnhill - 11 Aug 2003 23:15 GMT

If you have Excel, you can do this pretty easily, though if the table is
highly formatted (and especially if you have any merged cells), it may be
more trouble than it's worth to reformat the table. Here's how to do it:

1. Copy the entire table.

2. Paste into Excel.

3. Copy the cells in Excel.

4. Edit | Paste Special (to another location in the worksheet), checking the
"Transpose" box.

5. Copy the transposed data back into Word.

--
Suzanne S. Barnhill
Microsoft MVP (Word)

Signature

Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://www.mvps.org/word
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> Is there a quick (and I do mean quick) and dirty way to
> convert my rows to columns and my columns to rows?
> Thanks,
> --Susan

Reply to this Message