Importing an XML file into excel
- by Sudhee
I have a multilevel XML file. When I import the XML into excel, it creates multiple columns for the multilevel data. However, I need the multilevel data as additional rows.
Is there any way I can achieve this ?
Thanks a lot for your help.
My XML File:
<L1>
<L1dataId>07320</L1dataId>
…