Would it be possible for Excel to eliminate rows that are duplicates? If I have three identical values, the function will maintain one duplicate and remove the other two. If I have more than three identical values, it will keep two duplicates. It will keep 3 duplicates if there are 7 duplicates, and so on. For instance:
This is the original data that I want to remove:

This is how it should look like after the duplicates are removed along with the rows

Can VBA, formula, or other excel features do this?