0 (null) means the machine is idle (doesn't working on any process).
ROLL4 and ROLL5 are machines that used to process the Pro1 (Product 1). Product 1 is processed by ROLL4 for 2 hours, that's why h1 and h2 are filled with Pro1. If the next process is on ROLL5 for 2 hours then the table data will be like this :
The process on ROLL5 will begin at hour 3 (h3) until hour 4 (h4) at shift 2, since the product is done processing by ROLL4 at hour 2.
What is the script or function to make such result?
Sorry for my bad english...
And thank's for any attention and concern.