Typically used to remove duplications in lists, it can also summarize your data for unique values in specific columns.
Select Columns – select columns by position (shown with column letter for reference), or By Name, Duplicate rows are rows with the same values as another row in all of the selected columns.
Duplicates – select to keep or remove all rows that have duplicates, or to keep a single row for each, aggregating values in the other, unselected columns. For text columns, the ‘All (list)’ option will contain a comma-separated list of all values.
Singles – select to keep or remove rows that do not have duplicate rows in the table.
Ignore case – when performing the duplicate check, match rows even if they have differing upper or lower case letters.
Ignore spaces – when performing the duplicate check, match rows even if they differ because of different spacing (leading, trailing or within the text).
Add Count column – add a column to the table, named ‘Count’, with a count of the number of rows represented.
Blog article: Using the Duplicates Function