Custom column to group similar rows

I have a column with rows that I would like to group together in a new column. For example:

Into:

What's the custom column expression to group rows together like that, if there is one?