Sort and Filter.

Step 1:Click a cell in the table.

Step 2:On the Home tab select the Sort & Filter button, and select Custom sort (needed to sort on more than one column at a time).

Step 3:In the Sort dialog box select Sort by: Zero Scores, Order: Largest to Smallest, and click the Add Level button.

Step 4:Select then by: Ids, Order: Smallest to Largest, and click the OK button.

Step 5:Click the Zero Scores column header header arrow, select Number Filters, and clickDoes not Equal.

Step 6: In the Custom AutoFilter enter 0, and click OK

The result will look like: