4 Replies Latest reply on Jun 19, 2018 11:46 PM by Shinichiro Murakami

    Removing duplicates conditionally

    Joyanne Lizotte

      Hello,

       

      Does anyone know how to remove duplicates conditionally? I have a  large dataset where I'm trying to count items only once per site. For example my dataset looks like this:

       

      Site 1Item A
      Site 1Item A
      Site 1Item B
      Site 2Item A
      Site 2Item B
      Site 2Item B
      Site 2Item C

       

      And I'd like to remove the duplicate items for each site, so it looks like this:

       

      Site 1Item A
      Site 1Item B
      Site 2Item A
      Site 2Item B
      Site 2Item C

       

      There are other columns as well so the rows are not true duplicates, but I'm happy to ignore the rest of the data for now.

      Help please!