Analyze Clients

I am trying to analyze information from our database in excel.

Each time a client uses our service a row of information is created (in our database), with the client name being a part of the data set.
At the end of the month, we have about 700 rows of data and I need to analyze information on a client level.

To restate - we have may 700 lines of data that is divided among 20 to 40 clients per month.

Currently I am, copying the list of client names, sorting them alphabetically in a new column and deleting the names that repeat so that I have one column with the client's name only listed one time.
I am then using the SUMPRODUCT function to calculate statistics, reference the original data of 700 rows on these clients.

Help
Is there a simple way I could have the list of 700 rows collapsed to 20 or 40 so the client name is only listed once?

Is there a more advanced solution that what allow me not to have to create a new row of client names to analyze them?

Thanks in advance!

Jason
--