Match Column and Row

Hello,

I'm wondering if someone can help me figure this out. I'm trying to find the data in a given table and place it into another table that is separated by Month and Year (Month is Row and Year is Column). The attached file will explain it better. There are 2 tables, A and B. Please help me figure out how I can fill in the blank table.

Thank you for your help.

Hi
In the blue section:

c3 and across:
=LARGE((MONTH(B3)=MONTH($B$18:$AK$18))*(YEAR(C$2)=YEAR($B$18:$AK$18))*($B$19:$AK$19),1)

In the orange section:

H3 and across:
=LARGE((MONTH(B3)=MONTH($B$18:$AK$18))*(YEAR(C$2)=YEAR($B$18:$AK$18))*($B$20:$AK$20),1)

Please note that I change the formatting of the months and years in the tables, so that the formula will be able to capture these as months/years.

Originally Posted by TMS

Updated sample file

Hey guys - thanks for your input on this. I like your way TMS, but if I have more data further down the tables (see new attachment) and the dates continue on, Jan-21, Feb-21, etc. Would you still use your formula?

In my real life file, the main table (with dates Jan-18, Feb-18...) is quite large and continue to update as we finish a month.