Fill in missing dates in a range (prep for cumulative total)

[RBF]

Hi

I have a dataset of volumes by SKU (in excess of 100 SKUs) by month.  The month range is always from the current month to 10 months from now.

However, not every SKU has data for every month, creating gaps.  I need to fill in these missing values, just with a 0. 

I know how to create the running total, but I do not know how to fill in the gaps in the date range

Example below: 

[binuacs · Accepted solution]

@RBF One way of doing this

Note: Creating the test input file from the image is a time-consuming process, next time please provide the input file in excel

[RBF]

This works great, thank you!  The only thing I added was a Max_Count on the number of SKUs to make that <=2 dynamic

Noted on the spreadsheet upload ;)