Google sheet API downloads for grouped data

Hi, greetings!
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 .

Kindly help me.

Welcome to the community, @PrashanthSJ! Have you tried this with Excel Power Query?

Hi @Kal_Lam Thank you for quick response. I haven’t tried with Excel Power Query. Basically, I need it in Google spreadsheet as I wanted to link the data with Google Data Studio for visualising.