title: Delete duplicates and keep the topmost value
body: <p>I have consolidated two columns of data into one column in my spreadsheet, and color-coded them. There are about 300 duplicates in the list.</p>
  
  <p>How would I delete duplicates and keep the topmost value?</p>
  
  <p>Using the Delete Duplicates or Filter > Advanced Filter (with unique records only) removes duplicates from both lists (in the same column). I want the topmost list (which I have colored differently to the bottom one) to stay the same and the bottom list which may have duplicates from the top list to be shortened.</p>