Survey Data. Is this a pivot or a subtotal?

[excel-er-8]

I have looked at this data for too long. Here is my survey data:

[table="width: 500, class: grid"]
[tr]
[td]Team Name[/td]
[td]Q1[/td]
[td]Q2[/td]
[td]Q3[/td]
[/tr]
[tr]
[td]Alpha[/td]
[td]Yes[/td]
[td]Yes[/td]
[td]Yes[/td]
[/tr]
[tr]
[td]Alpha[/td]
[td]Yes[/td]
[td]No[/td]
[td]Yes[/td]
[/tr]
[tr]
[td]Beta[/td]
[td]Yes[/td]
[td]Yes[/td]
[td]Yes[/td]
[/tr]
[tr]
[td]Beta[/td]
[td]Yes[/td]
[td]No[/td]
[td]Yes[/td]
[/tr]
[tr]
[td]Beta[/td]
[td]No[/td]
[td]No[/td]
[td]No[/td]
[/tr]
[/table]



I'd like to total the number of Yes/No responses for each team for each question.


[table="width: 500, class: grid"]
[tr]
[td][/td]
[td]Q1[/td]
[td]Q2[/td]
[td]Q3[/td]
[/tr]
[tr]
[td]Alpha[/td]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td] No[/td]
[td][/td]
[td]1[/td]
[td][/td]
[/tr]
[tr]
[td] Yes[/td]
[td]2[/td]
[td]1[/td]
[td]2[/td]
[/tr]
[tr]
[td]Beta[/td]
[td][/td]
[td][/td]
[td][/td]
[/tr]
[tr]
[td] No[/td]
[td]1[/td]
[td]2[/td]
[td]1[/td]
[/tr]
[tr]
[td] Yes[/td]
[td]2[/td]
[td]1[/td]
[td]2[/td]
[/tr]
[/table]


Any help is appreciated. Thanks!

 

[sheetspread]

Unpivot the table first:

https://www.youtube.com/watch?v=xmqTN0X-AgY

then re-pivot with row and value as row, column as column, and count of value