I have a table which is looks like that:
1 2 3
3135-10 Style 1 Brown
3135-40 Style 1 Brown
3135-20 Style 1 Brown
4009-30 Style 2 Green
4009-10 Style 2 Green
4009-20 Style 2 Green
4009-CT Style 2 Green
3135-20 Style 1 Red
3135-10 Style 1 Red
3135-30 Style 1 Red
Is it possible to sort the table in this way?
1 2 3
3135-10 Style 1 Brown
3135-20 Style 1 Brown
3135-40 Style 1 Brown
3135-10 Style 1 Red
3135-20 Style 1 Red
3135-30 Style 1 Red
4009-10 Style 2 Green
4009-20 Style 2 Green
4009-30 Style 2 Green
4009-CT Style 2 Green
Because whatever I try it goes like that:
1 2 3
3135-10 Style 1 Brown
3135-10 Style 1 Red
3135-20 Style 1 Brown
3135-20 Style 1 Red
3135-30 Style 1 Red
3135-40 Style 1 Brown
4009-10 Style 2 Green
4009-20 Style 2 Green
4009-30 Style 2 Green
4009-CT Style 2 Green
Thank you very much in advance
1 2 3
3135-10 Style 1 Brown
3135-40 Style 1 Brown
3135-20 Style 1 Brown
4009-30 Style 2 Green
4009-10 Style 2 Green
4009-20 Style 2 Green
4009-CT Style 2 Green
3135-20 Style 1 Red
3135-10 Style 1 Red
3135-30 Style 1 Red
Is it possible to sort the table in this way?
1 2 3
3135-10 Style 1 Brown
3135-20 Style 1 Brown
3135-40 Style 1 Brown
3135-10 Style 1 Red
3135-20 Style 1 Red
3135-30 Style 1 Red
4009-10 Style 2 Green
4009-20 Style 2 Green
4009-30 Style 2 Green
4009-CT Style 2 Green
Because whatever I try it goes like that:
1 2 3
3135-10 Style 1 Brown
3135-10 Style 1 Red
3135-20 Style 1 Brown
3135-20 Style 1 Red
3135-30 Style 1 Red
3135-40 Style 1 Brown
4009-10 Style 2 Green
4009-20 Style 2 Green
4009-30 Style 2 Green
4009-CT Style 2 Green
Thank you very much in advance