How to populate work schedules into a specified format

[MiniLove]

Hi,

I'm a newbie and I would like some help.

I have a schedule where I know how many workers are working at specific hours. I would like to auto populate this Schedule into a different format which could look like under Output tab. For example, there will be 3 workers working at 1AM on 11/6 (highlighted in my sheet). I would like the output to show a separate row for each worker (Worker 1, Worker 2, and Worker 3) working at that hour on the same day. Could someone give me a direction on how I could solve this puzzle? Thank you in advance for your help!