BI Publisher Excel - How to get multiple horizontal repeating groups working?

Content

Hello There,

I would like to know how can I get the below output using BI Publisher for Excel.

I have three groups in the xml file.

G_1  ->  G_2 ->  G_3

Below expected output:

G_1		G_2		G_3
Segment1	Creation_Date	Line_Num	Item_ID	Quantity_Ordered	Quantity_Delivered
10001008	08 11 2019	10	300000013603844	200	100
		20	300000013612944	300	200
		30	300000013615636	10	5
		40	300000013626474	20	1
		50	300000013676169	2	2
10001009	22 11 2019	10	300000014432708	11	11
		20	300000014437123	25	25
		30	300000014434715	6	6

 

The output I am getting now is as below:

G_1		G_2		G_3
Segment1	Creation_Date	Line_Num	Item_ID	Quantity_Ordered	Quantity_Delivered
10001008" rowMark="2	2019-11-08T04:35:17.000+00:00" rowMark="2	10" rowMark="3	300000013603844" rowMark="3	200	100
		20" rowMark="3	300000013612944" rowMark="3	300	200
		30" rowMark="3	300000013615636" rowMark="3	10	5
		40" rowMark="3	300000013626474" rowMark="3	20	1
		50" rowMark="3	300000013676169" rowMark="3	2	2
10001009	22 11 2019	10" rowMark="3	300000014432708" rowMark="3	11	11
		20" rowMark="3	300000014437123" rowMark="3	25	25
		30" rowMark="3	300000014434715" rowMark="3	6	6

 

Please find attached the sample xml, output and the excel template file for your reference.