[Skunkworks] Merging multiple Excel worksheets (with a parent id) exported from ODK or Kobo

Hi Skunkers and Skunkettes, For those who have worked with ODK or Kobo for mobile data collection, how do you merge the eported data that is usually grouped into several worksheets (with a column referencing the parent_id row) into one sheet. In the resultant sheet, the parent row is repeated for every child row. Any ideas or solutions are welcome. -- Ndungi Kyalo