It is typically used to produce summary reports from detailed data.
Columns to Subtotal – select columns to be subtotalled by position or By Name. All unique combinations of values from the selected columns will be grouped.
Ignore case – when performing the comparison, match rows even if they have differing upper or lower case letters.
Ignore spaces – when performing the comparison, match rows even if they differ because of different spacing (leading, trailing or within the text).
Aggregation – select the aggregation to use when there are duplicate values.