Duplication when grouping (Many to many mapping)

612 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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?

1 Reply 1
4 - Data Explorer
4 - Data Explorer


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