sorting / grouping problem?
Posted by Devin on July 26, 2001 1:15 PM
Hi... my problem is as follows... I have information in an Excel spreadsheet as follows:
Name1 | item1 | 50,000 | location1|
| item 2 | 45,200 | location2|
| item 3 | 12,000 | location3|
Name2 | item 1 | 5,000 | location 1|
| item 2 | 7,000 | location 2|
Name3 |item 1| ......
and I would like to associate the names with the corresponding items, values, locations, etc. so that when I sort by name all the other information that goes with it from the other columns stays with it. Is there a way to group a number of rows together into separate groups? Thank you for your help.