I have two lists in separate files. They look something like this:

Month Product Qty Price Total
Jan Apples 54 3 162
Jan Oranges 21 3 63
Jan Plums 54 3 162
Jan Peaches 14 3 42
Jan Nectarines 24 3 72
Jan Bananas 64 3 192


Month Product Qty Price Total
Feb Bananas 5 2 10
Feb Oranges 3 2 6
Feb Plums 26 2 52
Feb Honeydew 54 2 108
Feb Watermelon 24 2 48


In my final product, I need to compare the two lists, but the twist is - I
need to add lines that show each product, so even if Jan doesn't have
Honeydew, I need to show a line in Jan that shows Honeydew with a Qty of 0.

So far, I've done a If(countif(range, criteria)1,True,False) to flag the
duplicates, then sort to group them together.

Should I now run a bit of code that inserts blank rows between each row,
then copy the content of the cell above each cell down?

I guess I could then split manually to see the data side-by-side, or use a
pivot table.

Any suggestions would be greatly appreciated!

--
Thanks!

Dee