I have a list of customer names (customer ID, name, state, city, zip,
and address). I want to know which customers are in what states. I
tried using a pivot table but it doesn't work. I want to use the the
pivot table format i.e. list of states in the Row label and the
corresponding customers and the zip in the value label. Any ideas?