Can anyone help me in providing solution to get the Grouped Data in Google Spreadsheets with Parent ID and Index number as it is downloaded in CSV or Excel file in Kobo collect Data–>> Downloads section.
I have a data set where in we are looking for a number of persons trained and their basic details such as name, age, contact details, etc. Under repeated group for each training conducted.
I tried several ways, somehow the data spread vertically only in columns in Gsheet when refreshed with API connectors. But, I need it in two different sheets one for main data and the second sheet with grouped responses with Parent ID .