XML Import
 

Hi,

When I import an xml doc into excel 2007 all the nodes are arranged on one
row. I would like for each subnode to be inserted on a new row. My simple xml
doc reads as follows:

<?xml version="1.0" encoding="utf-8" ?
<root
<aaaa
<english
something in english
</english
<swedish
something in swedish
</swedish
</aaaa
<bbbb
<english
something in english
</english
<swedish
something in swedish
</swedish
</bbbb
</root

Importing above xml results in:
something in english something in swedish something in english something in
swedish

when I would like it to result like this:
something in english something in swedish
something in english something in swedish

Never used excel before and would be greatful for any help on this.