title: How to remove duplicates of column by giving appropriate value to its label in the row?
body: <p>I have an excel table as follows (contains more data than displayed):</p>
  
  <p><a href="https://i.stack.imgur.com/FJrhI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FJrhI.png" alt="enter image description here"></a></p>
  
  <p>First column contains <code>ids</code>, second column contains <code>labels</code> and the row contains <code>unique labels</code> without any repetition.
  Here, I need to remove the duplicates in the <code>ids</code>, by giving value <code>1</code> to the appropriate <code>label</code> column per row.</p>
  
  <p>The expected out is:</p>
  
  <p><a href="https://i.stack.imgur.com/AOeAn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AOeAn.png" alt="enter image description here"></a></p>