group imported xml data according to keys

[bttrflii]

i have a dataset exported to xml from a windows application that i'd like to
import into excel 2007. i can import the xml file ok, but my "child" tables
don't import in with their associated "parent" row.

to use a simplified example, suppose that i have a parent table of "parent":

id | name
-----------
01 | ann
02 | ben
03 | carol


i have several other tables that reference the people id column in a
many-to-one relationship, one of which could be "kids":
id | pid | name
--------------
01 | 01 | zach
02 | 01 | yvonne
03 | 01 | xyver
04 | 03 | william

i'm currently getting an import that looks like this.
ann
ben
carol
zach
yvonne
xyver
william


what i would like excel to do is display this information with the child
tables near the parent row that they're associated with, such as (hopefully
this is readable):
parent | kid
ann zach
yvonne
xyver
ben
carol william


is this possible? i have control over the xml from the windows application,
so that can be changed if needed. the data (but not the schema) is
constantly changing, so i can't nail any number of "parents" or "children"
down.

any help is greatly appreciated.

 

[bttrflii]

attempt #2 on the "is this possible" example. "." denotes nothing and is
used for spacing purposes.

parent | kid
ann ... | zach
.......... | yvonne
.......... | xyver
ben
carol . | william

 

[bttrflii]

i've experimented with different xml schemas, but if they're the answer to my
question, i haven't found out how. does anyone have any ideas on how i might
be able to format my data with the child rows grouped with the parent row?