Sort "Messy" Excel Data - Bob Umlas Excel challenge

The task is to sort badly structured 1-D data that should ideally be in an Excel Table that would allow for easy or proper sorting. A challenge given to me by Bob Umlas at the Global Excel summit
Link to the workbook:
docs.google.com/spreadsheets/...

[@stevereed5776]

Good to have you back Victor, another masterclass, thank you.

[@IvanCortinas_ES]

Excellent solution. It is the typical problem that will make you think, both in Power Query and in Excel. Excellent logic, as always. Thank you very much, Victor.

[@ziggle314]

Very nice work. Thanks for sharing. This particular format is something I see all the time.

[@petercompton538]

Brilliant as ever! Thanks for sharing

[@maazziuche28]

you are my mentor, no cap!!

[@nadermounir8228]

Nice video thank you for your hard work

[@operamaniak81]

Beautiful.

[@rtrbs8383]

You are too awesome

[@Mark-sf4kh]

Amazinng!!

[@waitplanwp4129]

victor momo the best of best excel mvp!!!

[@jazzista1967]

Victor... very nice example.... and thanks for clarifying the confusion on when to use Wrapcolumns or Wraprows .. That has been one of the confusing points in my head and that it is why i have not use it at all...Nice to see you back making content again. It looks like you had a good time and also having the opportunity of rubbing shoulders with the excel elites! .... Is it possible to share the file? Take care and have a great day

[@benlcollins]

Great video, Victor! I'm curious what Bob Umlas' solution looked like...

[@williamarthur4801]

I'm going to put this on my todo list for tomorrow, any gossip from the summit? 😀😀

[@TheAlwaysGoel]

Good to see you bro where are you from

[@JoseAntonioMorato]

Following your solution I made other classifications.