From survey to pivot table!

[Cambuursterhoek1]

Hi there,

I did a survey for a sportsproject. Now that I got the data I want to put it in a pivot table. But I can't get things to work properly.


The survey is spread over 3 area's (Friesland, Groningen, Overijssel). From there I asked them a couple of questions (Row B - K) with a couple of questions were they had to answer on a scale of 5.

Could anyone help me with this?

Kinds Regards,
Choek1