title: Convert duplicate values to blank in column 1 and remove duplicates in column 2 for the value of column1
body: <p><a href="https://i.stack.imgur.com/9ya3k.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9ya3k.jpg" alt="Data and Result"></a></p>
  
  <p>In the above pic, in column 1 need to put blank when it is repeating and in column 2 only the data which is repeating next to column 1 should be eliminated. </p>
  
  <p>The data in column 2 can be repeated if it is next to some other value. For example, FB60 can be repeated in column 2 once for Chicago, once for Detroit and once for Houston, but it cannot be repeated more than once for Chicago, (more than once for Detroit and more than once for Houston.</p>
  
  <p>Sorry, the explanation is bit confusing, so let me know if you have difficulty in understanding so I can try to simply more for you.</p>