How to delete the last unwanted rows

Hello,

I am herewith attaching the example file which includes the real data. I want to sort the data according to the serial number in column a and delete the rest of the unwanted rows after sorting.

Thank you