There is a GROUPBY() function in Excel ... not for everyone yet but you may have seen the videos announcing it. Here's some good news for those of us who haven't got access to GROUPBY(), yet: Power Query has it and this video introduces you to it.
This video is part one of a two part series and it is aimed at showing you how to use Group By in Power Query. In part two you will explore some of the things you might do with the results of your Group By efforts!