Alice - If a field is text, there are only a few logical functions to be applied to groupings/aggregations of text values that are useful. One is a 'Singleton value' function defined as follows:

"If all the field/column cell values in multiple rows to be grouped/aggregated contain exactly the same text string value (case insensitive), then display just this one singleton value, else null (display a blank cell)"

The Singleton value text field grouping/aggregation function can be especially useful for scrubbing data, since you can (at a glance) see if there are more than one text string in a subset of cells you might expect to be uniform.