Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
Ranjiv Ranjiv is offline
external usenet poster
 
Posts: 1
Default How do I invert a table in Word?

I am using Microsoft Office 2003 Professional. I want to invert a table -
i.e. make the columns into rows, and the rows into columns. How can I do
this?
  #2   Report Post  
Posted to microsoft.public.word.tables
Luc Luc is offline
external usenet poster
 
Posts: 271
Default How do I invert a table in Word?

Ranjiv,
As far as I know not in Word, but if it is a relatively straigthforward
table you could copy paste it to Excel and transpose the columns into rows
and vice versa there. Then copy again to Word.

--

Luc Sanders
MVP - PowerPoint

"Ranjiv" schreef in bericht
...
I am using Microsoft Office 2003 Professional. I want to invert a table -
i.e. make the columns into rows, and the rows into columns. How can I do
this?


  #3   Report Post  
Posted to microsoft.public.word.tables
Jay Freedman Jay Freedman is offline
external usenet poster
 
Posts: 9,854
Default How do I invert a table in Word?

On Wed, 19 Aug 2009 04:10:01 -0700, Ranjiv
wrote:

I am using Microsoft Office 2003 Professional. I want to invert a table -
i.e. make the columns into rows, and the rows into columns. How can I do
this?


The technical term for what you want to do is "transpose" rather than
"invert". Word doesn't have a tool for that, but Excel does. Assuming
you have Office with both Word and Excel installed, you can transpose
a table as follows:

- Open both programs.

- Select the entire table in Word and copy it to the clipboard.

- Switch to Excel and paste into the first cell of an empty worksheet.
Each cell of the Word table will be placed into a separate cell of the
worksheet.

- Select the table you just pasted, and copy it to the clipboard.

- Click in an empty area of the worksheet, away from the existing
table.

- Click Edit Paste Transpose (I'm not sure exactly what that
sequence is, because I don't have Excel 2003 at the moment).

- Select the transposed table, copy it to the clipboard, and paste it
into the Word document. Delete the original table if necessary.

--
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.
  #4   Report Post  
Posted to microsoft.public.word.tables
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default How do I invert a table in Word?

Here's a macro that will do it in Word

' Transposer Macro
' Macro creaeted 18/01/1999 by Doug Robbins
' to transpose rows and columns in a table
Dim NumCols as Long, NumRows as Long, RowCounter as Long, ColCounter as Long
Dim CellText as String
NumCols = ActiveDocument.Tables(1).Columns.Count
NumRows = ActiveDocument.Tables(1).Rows.Count
ActiveDocument.Tables.Add Range:=Selection.Range, NumRows:=NumCols,
NumColumns:= _
NumRows
RowCounter = 0
While RowCounter NumRows
ColCounter = 0
While ColCounter NumCols
CellText = ActiveDocument.Tables(1).Cell(RowCounter + 1, ColCounter
+ 1).Range.Text
CellText = Left(CellText, Len(CellText) - 2)
ActiveDocument.Tables(2).Cell(ColCounter + 1, RowCounter +
1).Range.InsertBefore CellText
ColCounter = ColCounter + 1
Wend
RowCounter = RowCounter + 1
Wend


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Ranjiv" wrote in message
...
I am using Microsoft Office 2003 Professional. I want to invert a table -
i.e. make the columns into rows, and the rows into columns. How can I do
this?


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW DO I INVERT A TABLE in word 2007? Michael Hickey Tables 4 December 31st 08 09:46 PM
How do I invert text using Word 2007 Vista? Redditch Microsoft Word Help 5 August 29th 08 02:13 AM
Is there a way to invert text in a Word document? denisej77 Microsoft Word Help 2 May 5th 06 05:33 PM
How can you invert text in Word documents? Jeff Microsoft Word Help 1 February 27th 05 02:36 PM
How do you invert text in Word documents? Jeff Microsoft Word Help 0 February 27th 05 01:09 PM


All times are GMT +1. The time now is 04:05 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"