Turning a sheet of orders into a packing list
Hello, I am a baker and my customers order baked goods off a form and it populates to a google sheet that ends up looking like this (https://docs.google.com/spreadsheets/d/14HeZaIRTjIPuqTzsRIinp4coHiew2o4LAIuzRX\_8Luk/edit?usp=sharing). Ive deleted the email addresses and £££ amounts for privacy. What Id like is a formula on a fresh sheet that will take orders from this sheet of data and turn them into individual entries, one line for each bag, then have them all ordered according to certain rules. So i can have a sticker printer print each line out as a sticker and put each sticker on a bag, and then put into the bag whatevers written on the sticker.
The rules are, in order of priority
alphabetical order in the location column, so that each delivery locations bags are grouped together
loaves of bread always need a line to themselves because each bag can only fit one loaf (thats the columns named seeded, white, and brown)
dough balls always grouped together and max 2 balls per bag (thats the column called dough)
pastries (croissant, choc, swirl, raisin) maximum 3 per bag
all the whites grouped together, then all the seeded grouped together, and then all the browns grouped together. Then the dough balls ordered together. Then pastries orders at the end of each delivery location
Does that make sense?