Is it possible to group rows and have the sheet sorted by the first item in
the group? ie, we have orders with multiple items, and every item is on a
separate row, so if we wanted to sort the orders by the first item on the
order, is it possible to have that done and maintain the orders together?.
ie
I would want this:
order sku name
1 789 Bob
1 456 Bob
2 456 Sue
3 789 Joe
3 123 Joe
4 456 Jodi

Sorted like this:
order sku name
2 456 Sue
4 456 Jodi
1 789 Bob
1 456 Bob
3 789 Joe
3 123 Joe