Automatically insert rows based on lookup of data

[linksavage]

Updated example spreadsheet (attached) that should be easier to understand.

For any of you that may have helped me earlier today with conditional concatenation, this is the second part of what I now need. Thanks in advance!

In the attached spreadsheet, Grid 1 shows the current data, and Grid 2 shows the data that needs to be added to Grid 1 (based upon a lookup). Grid 3 shows the desired end result, which is the addition of 3 records. Please see the attached example.

Please let me know if this doesn't make sense!