Merge columns in data collected from a form

Hi, I had created a form which I have been editing as per my need. Currently its on version 21. I had grouped data into various groups in the initial version of the form, but as I was unable to view the whole form in a single glance, I removed the groups in the later versions of the form. Now when I attempt to download the data, the data under groups are not showing in the downloaded xls. In the data tab, the data under groups are shown in separate columns. There is no change in labelling or variable name. Just the groups (begin_group, end_group) were removed.
Is there a way to merge the grouped columns with the ungrouped columns? Is there a way to download the grouped data separately? I am a noob when it comes to using json forms and trying to retrieve dataset between 2 dates returns “The requested resource was not found on this server.” error.

An image to under the situation clearly

The fields hospital Id, age, gender, height, etc… are duplicated - in the old form they were under the “Demography” group. while in the new form the group demography was removed. Now I am not able to download the data collected from the old form. The columns are empty in the xls form and there are no extra columns representing the group/variable from which I can collect the old data

Solved the problem by removing “Select questions to be exported” option from the “Downloads” tab

2 Likes

Welcome to the community @cruderags!

:clap: :clap:

1 Like