Auto Merge Cell by Time Range

[js_excel]

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]MON[/TD]
[TD="align: center"]TUES[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]12:00 PM[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]12:30 PM[/TD]
[TD="align: center"]12:30 PM - 3:00 PM
ALEX[/TD]
[TD="align: center"]12:30 PM - 3:00 PM
ALEX[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]1:00 PM[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]1:30 PM[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]2:00 PM[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]2:30 PM[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]3:00 PM[/TD]
[TD="align: center"]3:00 PM - 4:00 PM
JAKE[/TD]
[TD="align: center"]3:00 PM - 4:00 PM
JAKE[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"]3:30 PM[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]4:00 PM[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]

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?

 

[mole999]

once you actually merge the cells, you then end up having to set formats and then that can cause problems with adjusting rows or columns for best layout