It sounds like something you could do with LOD. I'm using 9.2 and unable to open your workbook. If you don't get it figured out post some data in Excel and I'll mock something up.
Thanks Ivan! Turns out I just needed to right click and drag and drop, then select the monthly discrete option to get what I wanted.