Survey questions not showing in Excel Analyser Value section

[stephanealoo]

Hi @kouegoblaise
This is very normal for a repeat group. Your data from the repeat will be placed in a different sheet which can be identified using the Index and Parent ID. We do have discussions that have happened before on the forum around how to transform data from repeat groups.

Help merge dataset from the roster to the main sheet

Salut @samk The simplest approach is more of playing with excel functions as opposed to a KoBoToolBox approach. However since this is an issue face by most users, I will detail this here with external links. APPROACH 1: IF YOUR UNIT OF ANALYSIS IS HOUSEHOLD Step 1: Convert all your repeat data, which sit on separate excel sheets, from long to wide format. Kindly refer to this process to do this. Step 2: Merge back all the converted new wide-format repeats back to the main sheet using th…

Stephane