I am analyzing client sales and notice that there are duplicate records, each with sales, for many clients.
How do I merge these records to reflect total sales by client?