title: Delete Duplicates on the column without deleting the entire row
body: <p><a href="https://i.stack.imgur.com/LaT4z.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LaT4z.png" alt="enter image description here"></a></p>
  
  <p>I want to delete the duplicate data on the same column, without deleting the entire row the data is contained in, so the data>delete dups will not work on this problem</p>
  
  <p>the Data inside the cell, not the entire row, I want to leave the cells blank when the dups are deleted, why do I not want the entire row to get deleted? because the column next to this column also has data so deleting the entire row is not an </p>