Sort output data in Excel Template

Hi,

I am new one in using Excel templates and need some help to understand the sorting data in it.

Some time ago I have created a report (integrated in EBS) using RTF template and now I tried to create the same using Excel (output type is Excel and we need to reduce the output file size).

Everything looks fine but the sorting.

The simplified structure would be like:

<ROOT>
  <PERSON>
    <COMPANY>Company2</COMPANY>
    <LAST_NAME>LName1</LAST_NAME>
    <FIRST_NAME>FName1</FIRST_NAME>
    <COMMENT>Comment1</COMMENT>
    <CHILD>
      <C_LASTNAME>CLName1</C_LASTNAME>
      <C_FIRSTNAME>CFName1</C_FIRSTNAME>
    </CHILD>
    <CHILD>