View Single Post
  #2   Report Post  
Posted to microsoft.public.word.tables
Jay Freedman
 
Posts: n/a
Default convert columns into rows

On Sun, 27 Nov 2005 18:04:03 -0800, GreenEyedMedusa
wrote:

I really love the table function in Word; however, sometimes I've found that
I need to convert a row into a column or a column into a row and can't do it!
I really think that whatever new version of Word should have this function.


This function (called transposition) is provided by Excel, so
Microsoft decided it wasn't needed within Word. Here are the steps:

- Copy the table from Word to the clipboard and paste it into a blank
Excel worksheet.

- In Excel, copy the table again.

- Move the cursor to a cell in an empty area of the worksheet.

- On the toolbar, click the down arrow next to the Paste button and
select Transpose. The swapped table will be pasted in, with its top
left cell at the cursor.

- Copy the transposed table from Excel and paste it into Word. Delete
the old table. (Don't try to paste the transposed table into the old
table; you'll get a mess.)

If this is something you do often, it would be possible to program a
macro to do it in one step.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.