Questionnaire report with Question that has multiple answers - duplicating rows

Summary:

Has anyone successfully been able to get a report on questionnaires that has a 'check multiple choices' question on one row for an employee who selects multiple answers?

Content (please ensure you mask any confidential information):

Out of box, the report puts an employee on separate rows with each response checked on a different line when you turn the raw data table into a pivot table.

So if a teammate checks two boxes for one question, the raw data has the answers on two separate rows. We tried to turn into a pivot table to get it into one row, but it still duplicates the teammates information on two rows. Everything is the same except for the one question where they selected multiple answers.