SKIP IF Duplicate
I am trying to pull data from a source that has some duplicate entries (records) and I want to skip any records if a field value already appears in the previous records
AC01 | Red | Blue | Green
AC01 | Blue | Yellow - Red
AC02 | Green | Blue | Green
AC02 | Blue | Red | Green
In the scenario above I would only want to print one of the AC01 rows and one of the AC02 rows. doesn't matter which one. Just want to remove the duplicate row based on column 1.
Not sure if this is even possible.
Thank you in advance