Insert Rows automatically

Hi Excel Gurus!

Currently Consultants bill their hours every month only if their working hours is greater than 0.
To better visualize the data in graphs, we would like to normalize the data, by capturing (create rows) consultant details even if they haven't worked for a certain month. We would add 'zero' hours if they haven't worked. Can this be automated in EXCEL ?

Any Help is greatly appreciated. Thanks!

Insert excel rows automatically.PNG