consolidate rows based on ID

Another way.

1. Apply Filters.
2. In "Content" select Blanks.
3. Select the remaining IDs and delete them.
4. Clear the filter.
5. Select column A2:C10
6. Press Ctrl + G (or the F5 function key).
7. Click Special.
8. Select Blanks.
9. Click OK
10. Press Ctrl plus the "-" on the numeric keypad. (keyboard short cut for delete cells)
11. Select Shift cells up.

It takes longer to read than it does to do it.