Hi Excel Geniuses,
I need some help! Please note i am an excel novice. In chart 1 I have seasons that correspond to different time frames, sometimes they are the same.
In chart 2 i have the units that should be in those months, sometimes they need to be added.
And at the end is what i need it to look like based on cart 1 & 2. Can anyone PLEASE help???
[TABLE="width: 206"]
<colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>[TR]
[TD="colspan: 2, align: center"]TABLE 1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]Season[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"] 2[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD="align: center"]18MY[/TD]
[TD="align: center"]1/1/18[/TD]
[TD="align: center"]3/1/18[/TD]
[TD="align: center"]3/1/18[/TD]
[/TR]
[TR]
[TD="align: center"]18MA[/TD]
[TD="align: center"]12/1/17[/TD]
[TD="align: center"] 1/1/18[/TD]
[TD="align: center"] 12/1/17[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="colspan: 2, align: center"]TABLE 2[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]630[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]200[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="colspan: 3, align: center"]DESIRED OUTCOME[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]Dec-17[/TD]
[TD="align: center"]Jan-18[/TD]
[TD="align: center"]Feb-18[/TD]
[TD="align: center"]Mar-18[/TD]
[/TR]
[TR]
[TD="align: center"]0[/TD]
[TD="align: center"]630[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]55[/TD]
[/TR]
[TR]
[TD="align: center"]300[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[/TR]
</tbody>[/TABLE]
I need some help! Please note i am an excel novice. In chart 1 I have seasons that correspond to different time frames, sometimes they are the same.
In chart 2 i have the units that should be in those months, sometimes they need to be added.
And at the end is what i need it to look like based on cart 1 & 2. Can anyone PLEASE help???
[TABLE="width: 206"]
<colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>[TR]
[TD="colspan: 2, align: center"]TABLE 1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]Season[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"] 2[/TD]
[TD="align: center"]3[/TD]
[/TR]
[TR]
[TD="align: center"]18MY[/TD]
[TD="align: center"]1/1/18[/TD]
[TD="align: center"]3/1/18[/TD]
[TD="align: center"]3/1/18[/TD]
[/TR]
[TR]
[TD="align: center"]18MA[/TD]
[TD="align: center"]12/1/17[/TD]
[TD="align: center"] 1/1/18[/TD]
[TD="align: center"] 12/1/17[/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="colspan: 2, align: center"]TABLE 2[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]630[/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]200[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]100[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="colspan: 3, align: center"]DESIRED OUTCOME[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]Dec-17[/TD]
[TD="align: center"]Jan-18[/TD]
[TD="align: center"]Feb-18[/TD]
[TD="align: center"]Mar-18[/TD]
[/TR]
[TR]
[TD="align: center"]0[/TD]
[TD="align: center"]630[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]55[/TD]
[/TR]
[TR]
[TD="align: center"]300[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[/TR]
</tbody>[/TABLE]