Welcome to the Forum!
When you have time please introduce yourself here.
I took a look at the attachment you shared and it looks fine (no error).
The confusion might arise from the fact that you see two sheets rather than one.
I think this is the expected behavior.
The reason is that variables included in repeat groups are captured in separate tables/sheets (one per loop). In order to consolidate the observations you can merge the data 1:N using the field KEY and PARENT_KEY respectively.
"ODK Briefcase will export a set of CSV files, one for each repeating group."
Reference:
the logic is now replicated in Google Sheets.
Forum post in which the feature was discussed:
I hope this helps!
Best,
Andrea