Thought this would be useful to share with you all in particular @Melissa @BrianJ
Just a catalogue of most of the Power Query Functions for your needs.
Its a great visual way to seeing just how powerful and amazing Power Query Functions are!
Sadly I didnt create this application. Found this some years ago online (cannot remember) but I always use at work for solving real messy datasets. Hope this helps.