Duplication when grouping (Many to many mapping)

Hi everyone!

I’m having and issue and I’ve seen some threads that sort of touch on the topic, but none actually solve the problem for me.

I’m trying to analyse the answers of a survey and the big issue is when I attempt to group the answers by question.

I’ve created a an example data table here

If you look in the “Analysis” tab, I am trying to group by the Questions (Rollup), but the group are duplicating for each “version” of the entry.

Does anyone know of a simpler way to create a group for each question?


If we’re suppose to look at the “analysis” why didn’t you just link to that sheet ?? That would’ve made more sense

Aren’t there survey apps for this stuff? I guess airtable is suppose to be used for this stuff? I dunno

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.