We have information about some products. some Product, ProdName, Date, Store Ref or Ref Code are duplicated. Howerver, there is no identical rows.

Now, duplicated Products are removed. The Product column does line up with the rest of dataset anymore.

This time, duplicated values of ProdName column is removed. Again, this column does not line up with the rest of the dataset.

This time, duplicated values of Product, ProdName and Store columns are removed. If two rows have same Product ProdName and Store, they are supposed as duplicated.