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?

On Mar 9, 10:06*pm, RB wrote:
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?

You don't say which version of EXCEL you are using.

In EXCEL 2007 consider using:-

Data tab.

Sort & Filter group.

Either click on the Filter button or use the Sort button depending on
your preference / what you are trying to do.