Clean and Analyse repeat data from Kobotoolbox in Excel

How to clean and analyse repeat data from Kobo in Excel

[@twd2]

but the main HHs sheet will not be as same as the exact num of HHs it will repeat the HHs with the same num of repeat questions

[@eltonmaiela3156]

Hello can you help me? I downloaded my data in Excel and one of the question and response (like repeatable question) are not appearing in database.

[@firewbetru8233]

So how encoding data