Formula to create similar function to a pivot table

Hello,

I'd appreciate help with a file that I am working on. Not sure how to describe it but I have provided an example in the attached file.

I have data in the format presented in columns B and C. I need to create the result in columns F-J. Column F is provided and all the values are unique. Row 4 is provided as well and all the values are unique too.

I need to count how many times there is an overlap.