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 househo…

Welcome to the community, @gannahassan ! This support article shared previously should help you solve your issue: [image] New Support Article: Merging Individual Data with Roster Data through Power Query in Excel Support Article Dear All, Would like to inform you that we …

Merging datasets using STATA

User Support Data Management

Kal_Lam February 4, 2025, 4:09pm 2

Welcome to the community, @gannahassan! This support article shared previously should help you solve your issue: