Count number of dues in specific month

[uswyne]

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD="align: center"]Table 1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]Name[/TD]
[TD="align: center"]Uniform[/TD]
[TD="align: center"]Issue Date[/TD]
[TD="align: center"]Due Date[/TD]
[TD="align: center"]Shoe[/TD]
[TD="align: center"]Issue Date[/TD]
[TD="align: center"]Due Date[/TD]
[/TR]
[TR]
[TD="align: center"]AAA[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]31-Dec-18[/TD]
[TD="align: center"]31-Dec-18[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]01-Jan-18[/TD]
[TD="align: center"]01-Jan-19[/TD]
[/TR]
[TR]
[TD="align: center"]BBB[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]30-Nov-17[/TD]
[TD="align: center"]30-Nov-18[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]31-Dec-17[/TD]
[TD="align: center"]31-Dec-18[/TD]
[/TR]
[TR]
[TD="align: center"]CCC[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"]25-Nov-17[/TD]
[TD="align: center"]25-Nov-18[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]30-Novv-17[/TD]
[TD="align: center"]30-Nov-18[/TD]
[/TR]
</tbody>[/TABLE]

I need a formula to extract data from table 1 in to table given below.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Nov-18[/TD]
[TD]Dec-18[/TD]
[TD]Jan-19[/TD]
[/TR]
[TR]
[TD]Uniform[/TD]
[TD]02 (?)[/TD]
[TD]01 (?)[/TD]
[TD]00 (?)[/TD]
[/TR]
[TR]
[TD]Shoes[/TD]
[TD]01 (?)[/TD]
[TD]01 (?)[/TD]
[TD]01 (?)[/TD]
[/TR]
</tbody>[/TABLE]

Need help

 

[arthurbr]

Pivot Table