No merged cells.
I'm looking for a formula solution.
I would like for this formula to be ongoing.
The range(s) represent monthly values generated basically by projects as I tried to indicate in my example above - Project Alpha has three distinct phases. The entire project duration is nine months (Ph1=2 mos, Ph2=3 mos, Ph3=4 mos). The value generated by the first month is 20, second is 20, third is 25 and so forth.
Project Beta lasts for 10 months. The value generated by the first month is 15, second is 15, third is 15 and so forth.
I need to extract those monthly values and place them in a row format as shown in my second example above so that I can forcast optimum stating dates and monthly total values.
If there is a way to post an example, I'd give it a try. Thanks for your interest.