This problem is pretty similar to removing duplicates, except that I want to delete everything except for the unique strings that remain.
For example, I have two excel files where there are several URL’s, and when I remove the duplicate rows the result is like this:
Excel1:
www.123.com
Excel2:
www.123.com
www.321.com
www.cba.com
www.helloworld.com
Result:
www.123.com
www.321.com
www.cba.com
www.helloworld.com
What I aim to achieve:
www.helloworld.com
So I want to pretty much get rid of all the rows and data, except for the part that is unique and only has one of.
Is there any way to achieve that through Datatable filter or something?
Best regards
Robert