I need to create a pivot table type of file but unstead of pivoting on one item (such as a market) I would like to enable users to select from a list of groups (such as South East Markets). If the 'list' is selected each market would be listed (Tampa, Atlanta, etc). Does that functionality exist in Excel already? Do you know of software I can use that is out there? Please help [/i]