I have hundred of customers and 5 staff working on 3 types
of product. I am going to put the customers into 5 groups
and each staff responsible for one group. Considering the
workload of each staff should be similar to each other and
try to keep them specialized in product. Any analysis tool
in excel can help?

Pivot Table
Customer Product A Product B Product C Total
IBM 345 25 14 384
3M 23 23
Dell 456 67 523
HP 187 90 277