The new Query column can do this for you.
- Create a Query column targeting the data you want in your Collection, and define a sort column
- Use the Query column as the source of your Collection, and sort the Collection using your Group By column.
The new Query column can do this for you.