Understanding the design and then creating a table for Pivot Table

Hi, how do I design a table specifically to create the layout as per the "Photo" sheet?

I have only managed to get up to the work done in the "Test" sheet as per the attachment and really need to create that kind of pivot table for work reasons (urgent).



Can someone please advise me as I cannot seem to find any way to make approached and LinkedIn/No LinkedIn display numbers?

Edit: Original post made in myonlinetraininghub with same topic under General Excel Questions & Answers and also posted on Chandoo under Power BI, Power Query and Power Pivot