Extracting data from table to make new table

[BKGLTS]

[TABLE="width: 717"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]1/25/2019[/TD]
[TD]1/26/2019[/TD]
[TD]1/27/2019[/TD]
[TD]8/15/2019[/TD]
[TD]8/16/2019[/TD]
[TD]8/1/2020[/TD]
[TD]9/1/2020[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Item1[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD][/TD]
[TD][/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Item2[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD]100[/TD]
[TD][/TD]
[TD]Y[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Item3[/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD]50[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Item4[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Item5[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD]25[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 9"]The table above is how the data is formatted. I need help with formulas please to extract data out of this table and put it into the new table below.[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 9"]The new table must first determine column headers by looking at the dates in the source table column headers. It should include no more than one month for each year regardless of how many dates in that month are present in the source data, but only if there is at least some data in the column for rows containing the "Y". For example notice that AUG appears twice because they are different years, and notice that the column header doesn't populate with "SEP" in the new table for the 9/1/2020 column in the source table, because there is no data in the rows for that column that have a "Y".[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 9"]For the rows that have a "Y" the new table must then calculate the sum of all the cells in that row that fall within each respective month.[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 9"]For example, January of 2019 has three dates in the source table and totals 300 for Item 1. August 2019 has two dates in the source table and those cells total 200 for Item 1.[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 8"]All items should be represented in the new table regardless if there is any data included for them.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]JAN[/TD]
[TD]AUG[/TD]
[TD]AUG[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Item1[/TD]
[TD]300[/TD]
[TD]200[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Item2[/TD]
[TD]300[/TD]
[TD]200[/TD]
[TD]100[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Item3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Item4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Item 5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[BKGLTS]

This post was too complicated and confusing, I figured out some of it my own and reposted for help on the part i couldnt figure out. This post can be deleted.