String aggregation Function - List to Array

On multiple occasions, we have had a need to aggregate rows of data in a data designer or a rule where we wanted to flatten some string data during the aggregation into a single string array.  For example:

Starting Data:

When aggregating data in a transformation group by, it would be nice if you could designate a string field to be Flatten or something like below.  Even better would be to have the option to Flatten Distinct also.  This way the example below would be “Software, Support”.