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:
[TABLE="width: 551"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Start Time[/TD]
[TD]End Time[/TD]
[TD]Class Day[/TD]
[TD]CATALOG #[/TD]
[TD]CLASS SECTION[/TD]
[TD]Room[/TD]
[TD]Instructor [/TD]
[/TR]
[TR]
[TD="align: right"]10:30 AM[/TD]
[TD="align: right"]11:45 AM[/TD]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[TD]10[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 PM[/TD]
[TD="align: right"]1:15 PM[/TD]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[TD]13[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]3:00 PM[/TD]
[TD="align: right"]4:15 PM[/TD]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[TD]21[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]4:30 PM[/TD]
[TD="align: right"]5:45 PM[/TD]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[TD]24[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]1:30 PM[/TD]
[TD="align: right"]2:45 PM[/TD]
[TD]M[/TD]
[TD] 1A[/TD]
[TD]49[/TD]
[TD]BBC121[/TD]
[TD]Raleigh Roth[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]10:15 AM[/TD]
[TD]M[/TD]
[TD] 1A[/TD]
[TD]69[/TD]
[TD]BBC121[/TD]
[TD]Raleigh Roth[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]10:15 AM[/TD]
[TD]T[/TD]
[TD] 1AF[/TD]
[TD]06[/TD]
[TD]BBC121[/TD]
[TD]Abe Hampton[/TD]
[/TR]
[TR]
[TD="align: right"]10:30 AM[/TD]
[TD="align: right"]11:45 AM[/TD]
[TD]T[/TD]
[TD] 1A[/TD]
[TD]26[/TD]
[TD]BBC121[/TD]
[TD]Claudia Holmes[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 PM[/TD]
[TD="align: right"]1:15 PM[/TD]
[TD]T[/TD]
[TD] 1A[/TD]
[TD]42[/TD]
[TD]BBC121[/TD]
[TD]Claudia Holmes[/TD]
[/TR]
[TR]
[TD="align: right"]10:30 AM[/TD]
[TD="align: right"]11:45 AM[/TD]
[TD]W[/TD]
[TD="align: right"]2[/TD]
[TD]10[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 PM[/TD]
[TD="align: right"]1:15 PM[/TD]
[TD]W[/TD]
[TD="align: right"]2[/TD]
[TD]13[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]3:00 PM[/TD]
[TD="align: right"]4:15 PM[/TD]
[TD]W[/TD]
[TD="align: right"]2[/TD]
[TD]21[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]4:30 PM[/TD]
[TD="align: right"]5:45 PM[/TD]
[TD]W[/TD]
[TD="align: right"]2[/TD]
[TD]24[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]1:30 PM[/TD]
[TD="align: right"]2:45 PM[/TD]
[TD]W[/TD]
[TD] 1A[/TD]
[TD]49[/TD]
[TD]BBC121[/TD]
[TD]Raleigh Roth[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]10:15 AM[/TD]
[TD]W[/TD]
[TD] 1A[/TD]
[TD]69[/TD]
[TD]BBC121[/TD]
[TD]Raleigh Roth[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]10:15 AM[/TD]
[TD]R[/TD]
[TD] 1AF[/TD]
[TD]06[/TD]
[TD]BBC121[/TD]
[TD]Abe Hampton[/TD]
[/TR]
[TR]
[TD="align: right"]10:30 AM[/TD]
[TD="align: right"]11:45 AM[/TD]
[TD]R[/TD]
[TD] 1A[/TD]
[TD]26[/TD]
[TD]BBC121[/TD]
[TD]Claudia Holmes[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 PM[/TD]
[TD="align: right"]1:15 PM[/TD]
[TD]R[/TD]
[TD] 1A[/TD]
[TD]42[/TD]
[TD]BBC121[/TD]
[TD]Claudia Holmes[/TD]
[/TR]
[TR]
[TD="align: right"]9:30 AM[/TD]
[TD="align: right"]12:15 PM[/TD]
[TD]F[/TD]
[TD] 1A[/TD]
[TD]78[/TD]
[TD]BBC121[/TD]
[TD]Ana Romero[/TD]
[/TR]
</tbody>[/TABLE]
And this is what I want it to look like:
[TABLE="width: 655"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 656"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]M
[/TD]
[TD]T
[/TD]
[TD]W
[/TD]
[TD]R
[/TD]
[TD]F
[/TD]
[/TR]
[TR]
[TD]9:00 AM-10:15AM
[/TD]
[TD]
[/TD]
[TD]Roth 1A-69
[/TD]
[TD]Hampton 1AF-06
[/TD]
[TD]Roth 1A-69
[/TD]
[TD]Hampton 1AF-06
[/TD]
[TD]Holmes 1A-78 9:30 - 12:15
[/TD]
[/TR]
[TR]
[TD]10:30 AM - 11:45 AM
[/TD]
[TD]
[/TD]
[TD]Kim 2-13
[/TD]
[TD]Holmes 1A-26
[/TD]
[TD]Kim 2-13
[/TD]
[TD]Holmes 1A-26
[/TD]
[/TR]
[TR]
[TD]12:00 PM - 1:15PM
[/TD]
[TD]
[/TD]
[TD]Kim 12-1:15
[/TD]
[TD]Holmes 1A-42
[/TD]
[TD]Kim 12-1:15
[/TD]
[TD]Holmes 1A-42
[/TD]
[/TR]
[TR]
[TD]1:30 PM - 2:45 PM
[/TD]
[TD]
[/TD]
[TD]Roth 1A-49
[/TD]
[TD]
[/TD]
[TD]Roth 1A-49
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]3:00 PM - 4:15PM
[/TD]
[TD]
[/TD]
[TD]Kim 2-21
[/TD]
[TD]
[/TD]
[TD]Kim 2-21
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]4:30 PM - 5:45 PM
[/TD]
[TD]
[/TD]
[TD]Kim 2-24
[/TD]
[TD]
[/TD]
[TD]Kim 2-24
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
Thanks for any advice![/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 551"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Start Time[/TD]
[TD]End Time[/TD]
[TD]Class Day[/TD]
[TD]CATALOG #[/TD]
[TD]CLASS SECTION[/TD]
[TD]Room[/TD]
[TD]Instructor [/TD]
[/TR]
[TR]
[TD="align: right"]10:30 AM[/TD]
[TD="align: right"]11:45 AM[/TD]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[TD]10[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 PM[/TD]
[TD="align: right"]1:15 PM[/TD]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[TD]13[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]3:00 PM[/TD]
[TD="align: right"]4:15 PM[/TD]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[TD]21[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]4:30 PM[/TD]
[TD="align: right"]5:45 PM[/TD]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[TD]24[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]1:30 PM[/TD]
[TD="align: right"]2:45 PM[/TD]
[TD]M[/TD]
[TD] 1A[/TD]
[TD]49[/TD]
[TD]BBC121[/TD]
[TD]Raleigh Roth[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]10:15 AM[/TD]
[TD]M[/TD]
[TD] 1A[/TD]
[TD]69[/TD]
[TD]BBC121[/TD]
[TD]Raleigh Roth[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]10:15 AM[/TD]
[TD]T[/TD]
[TD] 1AF[/TD]
[TD]06[/TD]
[TD]BBC121[/TD]
[TD]Abe Hampton[/TD]
[/TR]
[TR]
[TD="align: right"]10:30 AM[/TD]
[TD="align: right"]11:45 AM[/TD]
[TD]T[/TD]
[TD] 1A[/TD]
[TD]26[/TD]
[TD]BBC121[/TD]
[TD]Claudia Holmes[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 PM[/TD]
[TD="align: right"]1:15 PM[/TD]
[TD]T[/TD]
[TD] 1A[/TD]
[TD]42[/TD]
[TD]BBC121[/TD]
[TD]Claudia Holmes[/TD]
[/TR]
[TR]
[TD="align: right"]10:30 AM[/TD]
[TD="align: right"]11:45 AM[/TD]
[TD]W[/TD]
[TD="align: right"]2[/TD]
[TD]10[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 PM[/TD]
[TD="align: right"]1:15 PM[/TD]
[TD]W[/TD]
[TD="align: right"]2[/TD]
[TD]13[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]3:00 PM[/TD]
[TD="align: right"]4:15 PM[/TD]
[TD]W[/TD]
[TD="align: right"]2[/TD]
[TD]21[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]4:30 PM[/TD]
[TD="align: right"]5:45 PM[/TD]
[TD]W[/TD]
[TD="align: right"]2[/TD]
[TD]24[/TD]
[TD]BBC121[/TD]
[TD]Kenya Kim[/TD]
[/TR]
[TR]
[TD="align: right"]1:30 PM[/TD]
[TD="align: right"]2:45 PM[/TD]
[TD]W[/TD]
[TD] 1A[/TD]
[TD]49[/TD]
[TD]BBC121[/TD]
[TD]Raleigh Roth[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]10:15 AM[/TD]
[TD]W[/TD]
[TD] 1A[/TD]
[TD]69[/TD]
[TD]BBC121[/TD]
[TD]Raleigh Roth[/TD]
[/TR]
[TR]
[TD="align: right"]9:00 AM[/TD]
[TD="align: right"]10:15 AM[/TD]
[TD]R[/TD]
[TD] 1AF[/TD]
[TD]06[/TD]
[TD]BBC121[/TD]
[TD]Abe Hampton[/TD]
[/TR]
[TR]
[TD="align: right"]10:30 AM[/TD]
[TD="align: right"]11:45 AM[/TD]
[TD]R[/TD]
[TD] 1A[/TD]
[TD]26[/TD]
[TD]BBC121[/TD]
[TD]Claudia Holmes[/TD]
[/TR]
[TR]
[TD="align: right"]12:00 PM[/TD]
[TD="align: right"]1:15 PM[/TD]
[TD]R[/TD]
[TD] 1A[/TD]
[TD]42[/TD]
[TD]BBC121[/TD]
[TD]Claudia Holmes[/TD]
[/TR]
[TR]
[TD="align: right"]9:30 AM[/TD]
[TD="align: right"]12:15 PM[/TD]
[TD]F[/TD]
[TD] 1A[/TD]
[TD]78[/TD]
[TD]BBC121[/TD]
[TD]Ana Romero[/TD]
[/TR]
</tbody>[/TABLE]
And this is what I want it to look like:
[TABLE="width: 655"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][TABLE="width: 656"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]M
[/TD]
[TD]T
[/TD]
[TD]W
[/TD]
[TD]R
[/TD]
[TD]F
[/TD]
[/TR]
[TR]
[TD]9:00 AM-10:15AM
[/TD]
[TD]
[/TD]
[TD]Roth 1A-69
[/TD]
[TD]Hampton 1AF-06
[/TD]
[TD]Roth 1A-69
[/TD]
[TD]Hampton 1AF-06
[/TD]
[TD]Holmes 1A-78 9:30 - 12:15
[/TD]
[/TR]
[TR]
[TD]10:30 AM - 11:45 AM
[/TD]
[TD]
[/TD]
[TD]Kim 2-13
[/TD]
[TD]Holmes 1A-26
[/TD]
[TD]Kim 2-13
[/TD]
[TD]Holmes 1A-26
[/TD]
[/TR]
[TR]
[TD]12:00 PM - 1:15PM
[/TD]
[TD]
[/TD]
[TD]Kim 12-1:15
[/TD]
[TD]Holmes 1A-42
[/TD]
[TD]Kim 12-1:15
[/TD]
[TD]Holmes 1A-42
[/TD]
[/TR]
[TR]
[TD]1:30 PM - 2:45 PM
[/TD]
[TD]
[/TD]
[TD]Roth 1A-49
[/TD]
[TD]
[/TD]
[TD]Roth 1A-49
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]3:00 PM - 4:15PM
[/TD]
[TD]
[/TD]
[TD]Kim 2-21
[/TD]
[TD]
[/TD]
[TD]Kim 2-21
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
[TR]
[TD]4:30 PM - 5:45 PM
[/TD]
[TD]
[/TD]
[TD]Kim 2-24
[/TD]
[TD]
[/TD]
[TD]Kim 2-24
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
Thanks for any advice![/TD]
[/TR]
</tbody>[/TABLE]