I need a support to structure my ODK xls form,
I am collecting data by countries, sub nationals and cities
I have realised my data structure doesnt help me.
I want to have country, sub national cities as column each but with what I have I have country subnational in ghana subnational, subnational in togo, subnational in etc
How do I ensure I have three columns that have my data structured Country, Subnational, City after pulling into excel