How to sort excel value and transform

Hi guys

I want to sort excel value based on row, see attachment[table="width: 500"], can anyone help?

Thanks a lot

itlyi2

Try this:

HTML Code: 

Thanks ikboy. Sorry i don't know how to run your code. All i did was to enabled developer tab in Excel and allow Excel to trust Macro. I never used VBA before, I opened VBA and created a new module, paste your code, click run, nothing happens.

Can you please let me know how to run the code. sorry for being an idiot here.

Thank a lot

itlyi2, if you try my code have nothing changes that is right, because the new answer were replaced yours.

sorry ikboy, when i run your code, nothing changes, i expect to see the new answer, but NOTHING is changed in excel workbook.