Sorting Excel VBA Macro : I'm looking for sorting a column in excel using a macro based on following criteria. I'm giving a sample below. Can you please let me know an algorithm to sort accordingly.

[Sort Sample][1]


  [1]: https://i.stack.imgur.com/FPvXQ.jpg