As described I’m wondering how i can “unpivot data” and download data in CSV.
My data looks like this:
Date / Name / Food / Frozen / Chilled
02-02 / somebody / 12 / 4 / 5
In this case I’d want toe downloadable data to appear as:
02-02 / somebody / Food / 12
02-02 / somebody / Frozen / 4
02-02 / somebody / Chilled / 5
I can get this to display correctly in repeating groups and using conditions etc -
But can’t get the data out of the RG (I guess because I have lines within the one RG element?)
If someone can give me some direction to explore that would be appreciated!