Complex Data Sort Challenge - Power Query Solution

I was contacted recently with a complex sort challenge on some data, and this video is my Power Query solution. You can also find my VBA solution to the problem in my article at https://www.myspreadsheetlab.com/excel-sorting-challenge/ This video will walk you through the steps to tur this awkward messy data into something Excel loves, and sorting it would be simple. And all this can be refreshed with 1 click of a button. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2t3netw The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1