Seems to me that ME is doing exactly what it’s supposed to do here. What you are looking for is the ability to specify multiple sort keys (otherwise, how does the code know what part of the non-key data you want to respect the ortdering of?).
A quick and dirty way to get the result you want would be to temporarily move columns 1-2 after column 5, which would leave you with:
then sort on columns 1-5, then move the columns back to the original order.
I beg to differ with your reply, and I do not want to move columns around.
Any Operating system sort will respect the original file row order when keys are equal. Multi-edit sort should do the same. Thus, when I sort by minor key first and have that in order, and then by major fields, the rows with duplicates (on 2nd sort) should respect the previous setl row sequence/order.
Just in case Multi-Edit sticks with QuickSort, here’s a kludge to retain the sort order you desire. Insert some columns into your file immediately after the columns you want to sort on. Use the Block Number feature to number them sequentially. Then sort on your columns plus the numbered columns.
If you want to be able to sort on multiple sets of columns simultaneously, and even do mixed ascending/descending sorts, you may be interested in the sort enhancement posted here: