The Hermit Hermit's Free Library  Brain Teasers

One in a series of exercises that demonstrate how to accomplish real-world computing tasks using time- and work-saving techniques.

Solution to Brain Teaser #2: Sort a Table and Transpose Columns

  1. Copy data to Clipboard and paste it into a new MS-Word document
  2. Select the text and convert it to a two column table (separate text at commas)
    How to convert a list to table
    Read about data sheparding
  3. Sort ascending on column 1
    How to sort a table
  4. Use Drag and Drop to transpose the first column and the second column
    How to transpose table columns
  5. Select the table and convert it back to text (separate text with Other, a space)
    How to convert a table to a list