Can this be done with a Pivot Table?

[Tkr567]

Sorry if this is very basic, I'm very much a novice on Excel - I'm just interested if this can be done.

I have an Excel table of survey results. The data is presented like this:

I was wondering if I could get a Pivot Table that counted the responses across all 5 questions, looking like this. I know I could do this easily with a normal Excel COUNTIF formula, but I wanted a Pivot so I could add a slicer for the 'Responder Project'
Desired Pivot Outcome:

I've been playing around but wasn't able to come up with anything that gave me a table that looks like the table above. Any suggestions?

 

[sandy666]

with Power Query Unpivot questions then with pivot table get what you want
or
just unpivot, group in PQ with Count rows
result will be the same

 

[sandy666]

Responder	Responder Project	Question 1	Question 2	Question 3	Question 4	Question 5
Name	Project X	Strongly Agree	Somewhat Disagree	Somewhat Disagree	Somewhat Disagree	Neither Agree Nor Disagree
Name	Project X	Somewhat Disagree	Strongly Agree	Somewhat Agree	Strongly Disagree	Neither Agree Nor Disagree
Name	Project X	Somewhat Agree	Neither Agree Nor Disagree	Neither Agree Nor Disagree	Somewhat Agree	Strongly Agree
Name	Project X	Neither Agree Nor Disagree	Neither Agree Nor Disagree	Strongly Agree	Strongly Disagree	Strongly Disagree
Name	Project X	Neither Agree Nor Disagree	Somewhat Agree	Strongly Disagree	Somewhat Agree	Neither Agree Nor Disagree
Name	Project X	Neither Agree Nor Disagree	Strongly Disagree	Somewhat Agree	Somewhat Disagree	Strongly Disagree
Name	Project Y	Neither Agree Nor Disagree	Strongly Agree	Somewhat Agree	Strongly Disagree	Strongly Agree
Name	Project Y	Strongly Agree	Strongly Disagree	Strongly Agree	Neither Agree Nor Disagree	Strongly Disagree
Name	Project Y	Somewhat Disagree	Somewhat Agree	Strongly Disagree	Strongly Disagree	Strongly Disagree
Name	Project Y	Neither Agree Nor Disagree	Neither Agree Nor Disagree	Somewhat Agree	Somewhat Agree	Strongly Agree
Name	Project Y	Strongly Agree	Neither Agree Nor Disagree	Strongly Agree	Somewhat Disagree	Strongly Disagree
Name	Project Z	Strongly Agree	Neither Agree Nor Disagree	Strongly Disagree	Somewhat Agree	Somewhat Agree
Name	Project Z	Somewhat Disagree	Somewhat Disagree	Somewhat Agree	Strongly Disagree	Somewhat Agree
Response	Count
Strongly Agree	12
Somewhat Disagree	9
Neither Agree Nor Disagree	15
Somewhat Agree	14
Strongly Disagree	15

let
    Source = Excel.CurrentWorkbook(){[Name="Table7"]}[Content],
    UOC = Table.UnpivotOtherColumns(Source, {"Responder", "Responder Project"}, "Attribute", "Response"),
    Grp = Table.Group(UOC, {"Response"}, {{"Count", each Table.RowCount(_), type number}})
in
    Grp

or Pivot

Response	Sum of Count
Neither Agree Nor Disagree	15
Somewhat Agree	14
Somewhat Disagree	9
Strongly Agree	12
Strongly Disagree	15

 

[Tkr567]

It works - thank you very much!

 

[sandy666]

You are welcome & thanks for the feedback
Have a nice day

note: next time not a pictures but XL2BB, please