XML-RTF report: parent nodes will not display with child nodes in a single-row

Hi

I am building an XML-RTF report that requires an excel table format.  All the fields are required to be in a single row.  My issue is that parent nodes will not display on the same line with its child node.  

For example:

Here is the expected outcome:

Account

PO

Vendor name

Item

Accrual Transaction

Source

Org

Date

Doc Num

Line

Unit of Measure

Quantity

Unit Price

200

109

MOTOROLA

DCT6200

Receive

PO*+

NDC

1-Sep-09

11492

1

EACH

-48

311.4628

Receive

PO*+

NDC

1-Sep-09

11492

1

EACH

-48

311.4628

Actual results:

Account

PO

Vendor name

Item

Accrual Transaction

Source

Org

Date

Doc Num

Line

Unit of Measure

Quantity

Unit Price