How to breakdown payments into single record for each month by Excel formula

I have few donors who will donate for different duration. I want to break down that duration into single records for each month. Attach is my sample input and desired output. I wish to do this by Exc...