How to "flatten" data from multiple Groups for basic Excel Template Output

Hi All,

I'm struggling with how to pull data from a higher-level group into a "flat" Excel output and looking for help.  For example, referencing the example EmpbyDeptExcelData.xml (attached), I'm looking to output data from both G_DEPT/DEPARTMENT_ID and G_EMP/EMPLOYEE_ID, G_EMP/EMP_NAME data in rows such as: 

Dept ID	Emp ID	Emp Name
10	200	Jennifer Whalen
20	201	Michael Hartstein
20	202	Pat Fay
30	117	Sigal Tobias
30	119	Karen Colmenares
30	115	Alexander Khoo
30	118	Guys Himuro

However, the data I'm getting is like (notice the missing Dept ID values):

  

Dept ID	Emp ID	Emp Name
10	200	Jennifer Whalen
20	201	Michael Hartstein
	202	Pat Fay