...
Use: To link villages to districts, you need one row per village. But because multiple villages can belong to a single district, this means as a result that you will have several rows where your district is repeated. CommCare will require a separate list for districts and a separate one for villages. For that reason, you will want to eliminate all the duplicate districts from your Excel spreadsheet.
How: (numbered steps correspond to the images below)
1) Select the columns containing duplicate data. Click "Data" on the toolbar, then click "Remove Duplicates"
2) Make sure that you select that your data has headers (if it does), and that you have selected the entire column. Click OK.
3) You will see a message box with the number of duplicate values that have been removed and the number remaining.
