A | B | C | |
1 | MON | TUES | |
2 | 12:00 PM | ||
3 | 12:30 PM | 12:30 PM - 3:00 PM ALEX | 12:30 PM - 3:00 PM ALEX |
4 | 1:00 PM | ||
5 | 1:30 PM | ||
6 | 2:00 PM | ||
7 | 2:30 PM | ||
8 | 3:00 PM | 3:00 PM - 4:00 PM JAKE | 3:00 PM - 4:00 PM JAKE |
9 | 3:30 PM | ||
10 | 4:00 PM |
<tbody>
</tbody>
The above chart is currently generated by way of VLOOKUP from a separate data sheet.
Is there a way to auto-merge cells B3-B7, B8-B10, C3-C7, and C8-C10 so it shows it as a block of time?