Jenny,
In the absence of a sample file, I can only work on the two examples you quoted in your post, so I've put together a file that demonstrates what I described earlier. The data is in columns A and B with headers in row 1 and a blank row between each multi-line record. This formula is in C2:
and this one in D2:
These are copied down beyond your data (to row 19 in the example file).
What you should now do is to fix the values in columns C and D, and then sort columns A to D using D as the first sort field and C as the second sort field - this will retain the order that you want within each record, as well as retaining the blank rows between records. After sorting you can remove the helper columns C and D.
Hope this helps.
Pete
Bookmarks