Merging customer names should solve the problem.   Change the name of a customer to something like "Old Customer"   then change another to the same name.  QB will ask this customer exists do you want to merge them?   Click yes.  Keep doing this and it will essentially keep reducing the customers by merging them.  With this method, you don't need to delete all the related activity.