May 25 2021 09:36 PM
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
May 25 2021 11:19 PM
@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.
May 26 2021 05:11 PM