I'm not trying to fill in null or missing values to what I have, but instead trying to find the easiest way to create a row similar to the others with the missing TranMonth where there wasn't a transaction.  By each ID there are TranAmnt, The TranMonths are how many months from the Close_Date the Transaction took place. The red in the example below is what I'm trying to fill in a record for... is there a way to do this. Everything else just needs to be zeroed out, I just need to the TranMonths, ID, and FaceValue to make it to each row...

Any ideas? Is this something that can/should be done in Qlikview or is this really meant to be done on the table side of things prior to loading in?