title: remove duplicate value but keep rest of the row values
body: <p>I have a excel sheet(csv) like this one:</p>
  
  <p><img src="https://i.stack.imgur.com/wrbqw.jpg" alt="Excel data"></p>
  
  <p>and I want the output(tab delimited) to be like this:</p>
  
  <p><img src="https://i.stack.imgur.com/tQDrY.jpg" alt="excel data 2"></p>
  
  <p>Basically:</p>
  
  <ul>
  <li>replace duplicates with blanks but
  
  <ul>
  <li>if <strong>col6</strong> value is different from the previous row for the same
  <strong>col1</strong>
  value, all the data fields should be included.</li>
  </ul></li>
  </ul>
  
  <p>I am struggling to create a formula which would do this. 
  If I try to "Remove Duplicates" it removes the value and shifts the values up one row. I want it to remove the duplicates but not shift the values up. </p>