The Concatenate option under aggregate would be more useful with the following options:
- Ability to specify a separator. It would be great to be able to concatenate and separate the values with a comma or pipe or even space. Example. ABC DEF GHI
- Ability to concatenate distinct values. This would be a useful, easy way to combine all the unique values of a group into one string Example: ABC ABC DEF -> ABC DEF