Number of repeats for n number of household members for n number of households

If I understand everything you just need nested repeats. Please take a look at this example:
samX.xlsx (34.1 KB)