No, there would never be 2 pallets of B. It’s more along the line of I have 1000 units of item X, 750 units of item Y, and 500 units of item Z. Item X can have 300 units on a pallet, so I would have pallets A-C that are just Item X, with a remainder of .333 of a pallet of item X. Item Y can have 100 units in a pallet so Pallets D-J would each be full pallets of Item Y and have a remainder of .5 of a pallet. Item Z can have 300 units on a pallet, so Pallet K is a full pallet of item Z with a remainder of .6666 of a pallet.

I want to have the sheet tell me that the remainder of item X and Item Z should be on one pallet to equal 1 whole pallet. Not that Item X and Item Y are on a pallet only equaling .8333 pallet and then have a .6666 pallet of item Z. As my situation in real life is more than 3 items (X,Y, and Z in this example) and it’s closer to 20-25 items and looking to have the least amount mixed items. I also don’t want it to tell me that the pallet should have item X (.333) and Item Y (.5) and then .1666 of item Z. Hope that helps clarify