I have imported XML file to excel 2007 using source & import functions in developer tab. I have mapped only few of the elements from that xml file.
But the imported data is out of sequence.
xml2excel.png

In the image above, u can see that the exported data's are not in a single row.

Expected:
I need excel to import data like in the image below.
xml2excel2.png

Please help me. .