I think I sort of understand what you're saying, but I'm not sure. My goal is
to sort the orders by the first item in the order, so in this instance if
there were two invoices that came through as:
Invoice sku name
A 3 Joe
A 1 Joe
B 1 Sue

Sorted, Invoice B would be at the top followed by Invoice A in the same
order that invoice A was previously so the data would look like:
Invoice sku name
B 1 Sue
A 3 Joe
A 1 Joe

Because the SKU in Invoice B would come before the first Sku in Invoice A.
Does that make sense?

"Nigel" wrote:

Your example does not seem to show any sort order? In general unless the
data to be sorted has one or more 'keys' to provide the sequencing then you
will not be able to do it. If the data is pre-sorted in as much the order
it is supplied in, then you might find adding a helper column with a
sequence number from 1 to n useful, you can then use that as part of a sort
routine within the other column(s) you wish to sort on.

--
Cheers
Nigel



"KNS" wrote in message
...
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