Hi - I have data that represents classes assigned to a room. Some classes are two days a week, some classes are 1 day a week. I would like to have a visual of the room utilization and open slots. I tried a pivot table with class start and stop time as a row and Class Day as a column. That doesn't seem to do it. Anyone have an idea for a grid. Here is a sample of one of the rooms with fake instructor names:
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
And this is what I want it to look like:
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Start Time | End Time | Class Day | CATALOG # | CLASS SECTION | Room | Instructor |
10:30 AM | 11:45 AM | M | 2 | 10 | BBC121 | Kenya Kim |
12:00 PM | 1:15 PM | M | 2 | 13 | BBC121 | Kenya Kim |
3:00 PM | 4:15 PM | M | 2 | 21 | BBC121 | Kenya Kim |
4:30 PM | 5:45 PM | M | 2 | 24 | BBC121 | Kenya Kim |
1:30 PM | 2:45 PM | M | 1A | 49 | BBC121 | Raleigh Roth |
9:00 AM | 10:15 AM | M | 1A | 69 | BBC121 | Raleigh Roth |
9:00 AM | 10:15 AM | T | 1AF | 06 | BBC121 | Abe Hampton |
10:30 AM | 11:45 AM | T | 1A | 26 | BBC121 | Claudia Holmes |
12:00 PM | 1:15 PM | T | 1A | 42 | BBC121 | Claudia Holmes |
10:30 AM | 11:45 AM | W | 2 | 10 | BBC121 | Kenya Kim |
12:00 PM | 1:15 PM | W | 2 | 13 | BBC121 | Kenya Kim |
3:00 PM | 4:15 PM | W | 2 | 21 | BBC121 | Kenya Kim |
4:30 PM | 5:45 PM | W | 2 | 24 | BBC121 | Kenya Kim |
1:30 PM | 2:45 PM | W | 1A | 49 | BBC121 | Raleigh Roth |
9:00 AM | 10:15 AM | W | 1A | 69 | BBC121 | Raleigh Roth |
9:00 AM | 10:15 AM | R | 1AF | 06 | BBC121 | Abe Hampton |
10:30 AM | 11:45 AM | R | 1A | 26 | BBC121 | Claudia Holmes |
12:00 PM | 1:15 PM | R | 1A | 42 | BBC121 | Claudia Holmes |
9:30 AM | 12:15 PM | F | 1A | 78 | BBC121 | Ana Romero |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
And this is what I want it to look like:
<tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
Thanks for any advice! |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>