Is there a way to have repeat group data in the same sheet?

Is there a way to have the repeat group responses in the same data sheet?

Hi @ahmadkhalid01,

Welcome back to the community! At the moment there is no way that you get the repeat group data in the same sheet in KoBoToolbox.

The design is that the data is processed as a long format i.e. one variable, one response per cell in excel. As such repeat gets more responses per question which have to be taken into a seperate sheet to keep this conformation. You may need to convert the data into wide format where repeating instances of the question in repeat are indexed. You can do this off the system in Excel using the matching index (process not explained within the forum)

FYI (discussion that has happened earlier):


1 Like