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

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until you provide a link or, for members with fewer than 10 posts, a comment telling us where else you have posted this query.)

Also x-posted here, too...
https://chandoo.org/forum/threads/un...t-table.48305/

Are there any other forums you posted on?