I managed to construct form with matrix questions and household rooster question and collect data using enketo but after downloaded the form in xls, result appear in different sheets according to matrix question I set first instead of all answer to appear in one sheet , your assistance on this
Welcome to the community! Kindly please be informed that if you are designing a matrix question you should generally see the results of the same in the main dataset. However if you have a repeat group question type (i.e. a roster question) the same stays in the next sheet (i.e. not in the main sheet).
You will need to merge the 2 dataset manually basing the
_index from the main dataset with the
_parent_index from the repeat group dataset.
Have a great day!
Thanks Kal_Lam. It worked for me.