Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Tables / November 2005

Tip: Looking for answers? Try searching our database.

convert columns into rows

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
GreenEyedMedusa - 28 Nov 2005 02:04 GMT
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.
Jay Freedman - 28 Nov 2005 04:15 GMT
>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.
GreenEyedMedusa - 28 Nov 2005 19:50 GMT
i know Excel offers transposition, but if one's interest is to make a table
of nothing but text, it's my opinion that Word is better because you can do
alot more text formatting, especially with bullet lists... to my knowledge,
Excel doesn't do that.  The bullet list function in tables (which Word
allows) is a really great tool for students who need to make charts of info
to study from.  That's why I would really like to see the transposition
function in Word.

> >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!
[quoted text clipped - 27 lines]
> Email cannot be acknowledged; please post all follow-ups to the
> newsgroup so all may benefit.
Doug Robbins - Word MVP - 28 Nov 2005 05:11 GMT
One day when in re-inventing the wheel mode, I created

' 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
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

Signature

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

>I really love the table function in Word; however, sometimes I've found
>that
[quoted text clipped - 12 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=2aee9db7-23e5-4
2c0-885f-7b47036ec36c&dg=microsoft.public.word.tables
 
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.