Distribute a Period over Multiple Columns

[Mathijs]

Hi everyone,

I'm struggling to distribute the Duration in column B over the correct period with a formula, in order to translate the table above indicating when a new project starts into the table below which sums up the current running projects.

For example, Project 1 has a duration of 2 months. As indicated in the table above, the project starts in January 2019. Is there a formula that distributes these two months to the according periods, starting with January?

The Running Projects table below should be the result. Does anyone have suggestions? Looking forward to think along.

Best,

Mathijs
# new projects started
[TABLE="width: 500"]
<tbody>[TR]
[TD]Project type[/TD]
[TD]Duration (months)[/TD]
[TD][/TD]
[TD]jan-19[/TD]
[TD]feb-19[/TD]
[TD]mar-19[/TD]
[TD]apr-19[/TD]
[TD]may-19[/TD]
[TD]jun-19[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD]2[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

# running projects cumulative
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]jan-19[/TD]
[TD]feb-19[/TD]
[TD]mar-19[/TD]
[TD]apr-19[/TD]
[TD]may-19[/TD]
[TD]jun-19[/TD]
[/TR]
[TR]
[TD]Project 1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Project 2[/TD]
[TD][/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]