Generate Rows based on variable conditions

[StellaBon]

Hi folks,
I have a need to generate missing rows. If there are two "Total People", it should search in column "Person" for numbers 1 and 2. 
If any numbers <= to the total number in "Total People" are missing, it should generate those rows. 

So in my first image where it is wrong- there are 2 "Total People" but only records for person #2. The correct result would look like the second image where "Person" #1 and "Person" # 2 now exist.

The number of "Total People" may vary. Sometimes all are accounted for. Other times I may have 10 total people but only "Person" #3 and Person #5 exist in the data.

Is there a dynamic way to determine and fill in the missing records from "Person"?


Thanks you,
S-Bon