Dakota software's
Toolkit for Adagio, specifically the Customer Changer module, will help with this.
It allows you to import a list of customers to be combined into a single customer code. You can then delete that customer.
Saves a lot of time and works really well for a number of our clients.