Sort data 1,2,3,4 1,2,3,4 NOT 1,1,2,2,3,3,4,4

[johnnygrr88]

Hello Folks,

I am trying to create a VBA macro to sort data in a spreadsheet in the following order:
1,2,3,4
1,2,3,4
1,2,3,4
5,6

Rather than the traditional 111,222,333,444,5,6 that you get through the normal Sort options.

Thank you in advance,

John