I want to delete duplicate entries in the following table:
The problem is that I only want to delete the duplicates in the left hand column, and the right hand column entries must stay with their corresponding row, so that the table becomes:
When I follow the advice given here, I get this:
Which is still not right as there are still duplicates in the left hand column. The problem is that it sees the rows as unique, although I am actually only interested in the left hand column.
Any advice?