Duplicates/Join

[furlonla]

Hi, 

I am trying to identify all the duplicates from my dataset (see photo), I want the first two Nulls to read duplicates. What is the most straightforward way to do this?

Any help would be much appreciated!

Thanks,

Laura

[afv2688]

Hello @furlonla ,

This may be the easiest way to find the duplicates with their originals. If you use only the unique tool you wouldn't be able to have all the values on the same output.

Hope it helps 🙂

Regards