How to add to missing/NULL values after creating a table from merging two data sets

[ChrisNZ]

1. Provide the values expected in place of the missing values.

2. Provide the logic used to derive those values.