Getting data from repeat groups into one sheet within excel

[stephanealoo]

Hi,
This is by design. You are not able to get the data within the same sheet since the repeat groups have multiple data points for a single instance. See the discussions that have happened here before

When i download my data it comes in different sheets, how do i make them appear in one?

Hi @mmarwa, You generally see 2 or maybe more sheets in your downloaded xls dataset when you have repeat group questions within your survey questionnaire. Please note that the first sheet that is generally seen when opening your xls dataset is the main dataset. This dataset contains a variable named _index. If you go to the next sheet (which should be your first repeat group sheet) you should see a variable named _parent_index. Theoretically, the number of cases in your first sheet (default s…

Stephane