I think you'e going to have to write (or have help writing) a custom sort.
Excel doesn't do well in defining multiple  rows into a record.
If you can send me a file, I'd be glad to take a look at writing a sort  routine.
Do you have specific sort fields or would you like to select them?
I can make a form that will allow you to define the sort sequence,
or we can hard-code the sequence.