[invictius]

Not sure how to sort the data from most to least km (in column J without affecting the data relative to the other columns. here she is

[seadave77]

Select all your data then goto Data - Sort. Sort by column J descending. If you do it wrong just undo.

[invictius]

Originally Posted by seadave77

Select all your data then goto Data - Sort. Sort by column J descending. If you do it wrong just undo.

"this removes the subtotals and sorts again. if you want to sort the subtotaled groups, choose the cancel button; then collapse the outline and try again."

Needless to say, I lose all info relative to the other columns...

[Omsion]

You only lose the subtotals in this case.
Can't sort individual values freely with subtotals involved.
If you want to be able to sort freely, then I would get rid of the subtotals (which does remove the nesting, unfortunently) and use SUMIF.

SUMIF(<cell range>,<condition to check cell range on>,<actual cells to sum>)
<cell range> and <actual cells to sum> would be the entire range of all your data. Repeat for the different labels.