I did a vegetable and fruit market survey for street vendors in the market. The students observed the movement and the selling products of these street vendors for 3 hours. There are tow groups and few repeat questions in one of the group in the form. The data is in the process of collection. I downloaded the data to study the pattern and type of data coming in kobo. But facing some difficulties in establishing the unique link between common question and repeat questions. The answer to repeat questions are in sheet2 of the excel file.
I would like to know the unique link field in a repeat question. I downloaded the data in XLS format and found that there are two separate sheets in the excel file. Can someone let me know how to identify the unique link field which I can link and compare between two sheets of excel file. Currently I am unable to see any unique field which establishes the link between two sheets for data analysis.
Your input to resolve this will be highly appreciated.