Thank you so much , but it doesn't seem to work. When you choose two columns it fails to sort in order and only gets worse as there are more columns...with regards to the formatting, I can solve that issue through conditional formatting.

Please help me get the sorting correct!