| 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?
