Combination to match each quantity in excel

I have a excel file with Size, color and quantity. A design team use this file to find out how many plate I need and how many of each size I will put in a single plate, so that total of each size qua...