Data downloading onto separate Excel tabs that are not linked

Hi,

I’ve added a repeating group to my survey in order to collect data that would otherwise be collected in a table on a paper survey (details on household). The repeating group works well and can be repeated for each member of the household we need to get information on. The issue is that when i download the data into excel, the repeating group questions come into a separate tab which does not appear to be linked to the rest of the responses — the id columns are blank.

How do you link responses from a repeating group to the rest of the responses from that survey? I’m worried that these questions are going to be useless!!

Thanks,
Kathy