I have an excel table as follows(contains more data than displayed)
snip1.PNG
first column contains ids, second column contains labels and the row contains unique labels without any repetition.
Here, I need to remove the duplicates in the ids, by giving value "1" to the appropriate label to the row
The expected out is
snip2.PNG
Bookmarks