Employee number according to timetable sequence

[aligahk06]

Dear All,

I want my attached excel file in following order.


1. Column D consist time table name.

I want this time card in order of timetable name irrespective of employee sequence.
i.e all employee who has 06:00 - 14:00 timetable appear first then all employee who has timetable 07:00 - 15:00 appear next and 08:00 - 16:00 and then 08:30 - 17:30 and so on.

It help me to trace out how many employee attached with each timetable in sequence.
Attached file for ref. Any help deeply welcome.
solution needed....


Rgds,
aligahk06