Pivot data

Hello,

Good day.

I have a sample survey data on sheet named "Database", data are collected from the sheet named "Survey Sheet".

My needed results are shown in sheet named “summary”

I have tried to use pivot table to show these results but it seems my database is not organize or not correctly set-up to show the results I wanted.

Any help or guidance will be greatly appreciated.

Thanks in advance.