View Single Post
 
Old 07-04-2011, 03:10 AM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Moor215,

To convert the data to a table, I had to do extensive clean-up work first, removing 'headings' embedded in the data, multiple tabs & spaces between 'columns', and also at the ned of each line. Ultimately, each line ended up as basically 'text' tab 'text' tab 'text'. I then selected the whole document and used Word's 'convert text to table' function. Finally, I simply dragged the second column ahead of the first column. Took somewhat less than an hour.

Sorting is easy: Click anywhere in the table, then choose Table Tools > Layout > Sort and choose the sorting arrangement of your preference.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote