   sorting/grouping by rows in Excel
  Let's say that you have three columns and three rows in Excel.NAME    COST  PAGESDictionary   $40   1000Bible   $10   400Almanac $20   800How would you "associate/group" all the column values for a single rows, so that if you sort by PAGES, the associated NAME and COST columns are also sorted?  For example, if sorting by PAGES, you would get:NAME    COST  PAGESBible   $10   400Almanac $20   800Dictionary   $40   1000By NAME:NAME    COST  PAGESAlmanac $20   800Bible   $10   400Dictionary   $40   1000I see that Excel has a row grouping function, but it hasn't been performing as I described above, so perhaps there is another way.Thanks.   
  Select the entire table (4 rows x 3 columns), hit data|sort and click that you have headers in your table. Choose how you want to sort and... voila!(note: this behaviour varies slightly across different versions of Excel)   ;  Thanks!  Works great!   