Sorting while grouping

Hello,

I have a 3000 line excel. I have 1 column that contains order numbers (Order Number) and another column that contains item numbers (Vendor SKU).
I need to sort my excel by item number, but I need to keep all the same orders together, so basically if I have the same item number 100 times on the excel, I need them to come one after the other with the exception of the other item numbers in the same order.
Example;
Order # Item #
123 ABC
123 ABD
124 ABE
125 ABC
126 ABC
I need the results to be;
123 ABC
123 ABD
125 ABC
126 ABC
124 ABE

Please help!

Thanks in advance

Use sort dialog box (not just A->Z or Z->A buttoms) and there you can declare several keys of sorting, so as a first key use orderNo and second key ItemNo

Just to make sure - you added an attachment, but there is just one list. I assume it is current state - what would be expected result? Of course whole list is too long to do it manually, so use some 20 top rows and rearrange their order.

Kaper, I am attaching the file again, but in sheet 1 I am showing my desired results.
Thanks in advance for your help!

OK. So it is a bit more complicated - we will need three keys sorting. See attachement and brief explanation:

I made a list of all vendors SKUs (copied column D into J, removed duplicates, sorted ascending) and assigned them numbers 1...361 (there is 361 unique SKUs) in column K.

Then in F2 I wrote number for this particular vendor SKU number

Formula:

Please Login or Register  to view this content.

and in G2 smallest number for any vendor SKU in given orderNo (array formula *):

Formula:

Please Login or Register  to view this content.

and copied both formulas down

Now the range A1:G3520 has to be sorted on 3 keys: smallest vendor SKU number for given order, order number, vendor SKU number (see picture - sort dialog is in Polish, but elements are located the same way in any national/international version of Excel).
Of course once rady you can get rid of all columns F:K


*) ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.