how to calculate the total of survey record to match two fields????

[bbsin]

hi 

anyone can help, I have a huge list  I need to find the total of feedback provide 6- Strongly Agree to 1 Disagree to match the Topic to the Q1 or Q2.. etc.. how to?

Thank you

[#2]

@bbsin since you mention "a huge list", I would consider using Power Query (PQ) and a pivot table.

First unpivot the survey results in PQ and load the data to the data model and then re-pivot all, counting the number of occurrences by answer.

I've created a mock-up based on what you showed in your picture. Is that something you could work with? See attached workbook.

[#3]

@Riny-van-Eekelen

Thank you will try out.