Hi.
I'm a school timetabler and for irrelevant reasons need to split the day into 20 minute slots.
We have two lengths of lessons, 60 minutes and 100 minutes.
When I export the timetable from the timetable software to excel I get the class name duplicated in three cells for 60 minute lessons and five cells for 100 minute lessons.
I would like to know how to select the groupings, remove the duplicates within the grouping, leave one class name and merge & center.
Class names will be repeated for classes at different times in the day and week in other groupings so I don't want all duplicates to be removed, just the ones within a grouping.
Some class groupings will not have a blank cell in between but will have a different class name.
I hope I've explained myself!
Thanks in advance.
I'm a school timetabler and for irrelevant reasons need to split the day into 20 minute slots.
We have two lengths of lessons, 60 minutes and 100 minutes.
When I export the timetable from the timetable software to excel I get the class name duplicated in three cells for 60 minute lessons and five cells for 100 minute lessons.
I would like to know how to select the groupings, remove the duplicates within the grouping, leave one class name and merge & center.
Class names will be repeated for classes at different times in the day and week in other groupings so I don't want all duplicates to be removed, just the ones within a grouping.
Some class groupings will not have a blank cell in between but will have a different class name.
I hope I've explained myself!
Thanks in advance.