Hi! i am using a household questionnaire in Kobotoolbox. When i download the data in excel form i get 4 separate sheets in the same form. When i merge the 4 excel sheets in STATA, i get the same household distributed in 3 rows. How to solve this issue? i need to get each row representing one household. Thanks in advance!
Welcome to the community, @gannahassan! This support article shared previously should help you solve your issue:
