It is typically used to produce summary reports from detailed data.
Select Columns – select columns to be subtotalled by position or By Name. All unique combinations of values from the selected columns will be grouped.
Aggregation – select the aggregation to use for numeric columns when there are duplicate values in the selected column.
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).
Updated for v10.