Hiding blank cells on a excel schedule

[darbro]

Good day,

My situation is, I have a excel schedule that at time has employee's that are borrowed from another department. This results in many blank cells on my schedule, leaving a void between other employees.

My question is. Is there away to hid these blank cells without removing the employees name and shift they have and will work in the future?

Thank you,