I have downloaded my Kobo responses, and they appear to be grouped into several categories in Excel. However, the questions in Kobo are based on groups. I don’t want the downloaded version of the groups to be in separate sheets. Is there a way to achieve this and have all the responses in one consolidated sheet?
@mireillejazi, it seems like you had repeat groups in your survey project. And when trying to download them, you see data in separate sheets. Maybe you are trying to get all the data in a single sheet. Am I correct?
Hello @Kal_Lam, thank you for your quick response!
Yes, that is exactly what I want to achieve. Is this possible?
@mireillejazi, this is not possible within the system. But you should be able to do it as outlined in the support article through
Excel Power Query: