Sorting drop-down list data by Day of the week and then time

[mj_bowen]

Hi,
I have some data from two drop-down lists that I would like to sort.
The data is in two columns
1: 'Day of the week'
and
2: 'Time'
I would like to be able to sort the drop-down data so that
it is in order of days then timeslots - eg, all the Mondays in time order, followed by all the Tuesdays in time order etc.
Is this possible?
I've tried using a filter but it puts Thursday before Tuesday and doesn't always get the other days in order either.
Not sure how to solve this?

Any suggestions would be welcomed,
kind regards,
MJ

Here is a link to the sheet:

Days and Time slots

Sheet1 DAY OF WEEK,TIME Wednesday,20:30 - 21:20 Wednesday,14:30 - 15:20 Tuesday,12:30 - 13:20 Tuesday,09:30 - 10:20 Thursday,11:30 - 12:20 Thursday,18:30 - 19:20 Sunday,16:30 - 17:20 Saturday,14:30 - 15:20 Monday,11:30 - 12:20 Monday,17:30 - 18:20 Friday,10:30 - 11:20 Friday,12:30 - 13:20 Friday...

docs.google.com

 

[SunnyAlv]

Like this ?

with SpreadSheet

=LET(Data,A2:B14,Days,SWITCH(A2:A14,"Monday",1,"Tuesday",2,"Wednesday",3,"Thursday",4,"Friday",5,"Saturday",6,"Sunday",7),CHOOSECOLS(SORTN(HSTACK(Data,Days),13,1,3,TRUE,2,TRUE),1,2))

or Excel

=SORTBY(E5:F17,SWITCH(E5:E17,"Monday",1,"Tuesday",2,"Wednesday",3,"Thursday",4,"Friday",5,"Saturday",6,"Sunday",7),1,F5:F17,1)

 

[mj_bowen]

Hi SunnyAlv,

Thank you so much for sorting this - not sure how you did it but it works!
I have added some sample pupil names to one of the sheets as my ultimate aim is to be able to
sort pupil names dependent on their day and time slots chosen - I thought I would be able to adapt but it is way beyond me!
Is this extra layer of sorting possible?
kind regards,
MJ

 

[SunnyAlv]

Hi SunnyAlv,

Thank you so much for sorting this - not sure how you did it but it works!
I have added some sample pupil names to one of the sheets as my ultimate aim is to be able to
sort pupil names dependent on their day and time slots chosen - I thought I would be able to adapt but it is way beyond me!
Is this extra layer of sorting possible?
kind regards,
MJ

hmm, maybe that's possible, you could attach a picture/table so I can help

 

[mj_bowen]

Hi SunnyAlv,
Thank you so much for your 'Solution2' - I'm assuming this was you - it is exactly what I was looking for it to do, you are a legend! - apologies for not replying sooner, I've been distracted from this task but now back on it!
I will have a go at using the solution 2 on my master sheet and let you know if it works!
kind regards,
MJ

 

[mj_bowen]

...p.s..what would be the best way to use the solution 2 - would you have it all on one sheet and hide the columns or split it over two sheets as this demo one is set up?