How to remove duplicate records easy way

[fomenter]

Hi,

I have single column with product names, and I would like to remove the duplicate records

Ex:

Panasonic xl10

SIXA 

Traszon

SIXA

Panasonic

There are two SIXA, so we remove one (note: we only look for exact match, so Panasonic vs Panasonic xl10, they both stay)

I already tried filter function, but could not figure out how I could remove it

Thanks

[Joe_Lipski]

Try the Unique tool (Preparation category) or the Group By option in the Summarize Tool (Transform category).

[roadhouse · Accepted solution]

Use the summary tool and group on product name. Bam!