Hello,
I have data like this.
1, red
1, blue
2, purple
2, purple
3, yellow
3,red
I'd like to edit the data to show the data like this:
1, red
2, purple
2, purple
3, yellow
So I'd only like to only keep duplicates if the first and second field each have a match in the data. Any ideas? Assuming it is ETL somehow but can't wrap my head around it.