Looking for the right approach

Hello,

I'm trying to make some kind of tool for the people in my warehouse to combine deliveries in 1 pickrun.
So in this case there are several criteria which have to be followed.

- First a sorting has to be done in order types. The first 2 digits define the order type. Should I do this with pivot tables? Problem is that a delivery can have more lines but has to stay together.
- The second criteria is to combine deliveries to a maximum of 1.5 m3 WITH the best possible outcome of article overlap. This is mainly where I dont know how to approach this project in the best way.

Thanks in advance,
Tim