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. .
Bookmarks