Displaying XML Data in excel Sheet. How for the following query ?

[NimishK]

Anyone
How to to display the Following in XML with Following
<co name=""><add1><add2><PHP>
<a1><b1><city><Header>Co Name</Header>
<Address>Add1</Address>
<Address>Add2</Address>
<A1>
<B1>
<customer>ABC Co</customer>
<address>123 Main</address>
<city>Salem</city>
</B1>
</A1>



</PHP>
</city></b1></a1>Output in Excel should be like below as with XML file

ABC Co
N2345 Lane
NJ-23456

customer address city
ABC Co 123 Main Salem

Some how not able to display the Co name its Add1 and Add2
Thanks and Regards
NimishK
</add2></add1></co>

 

[NimishK]

Excuse me for the above post . Sorry I could not lay down in Proper format
Inconvenience Regretted
How to to display the Following in XML
XML Tags

<Header>Co Name</Header><CoAddress>N2345 Lane </CoAddress><CoAddress>NJ-23456</Address>

<A1>   <B1>	<customer>ABC Co</customer>	<address>123 Main</address>		                <city>Salem</city>   </B1></A1>

Output in Excel should bel ike below as with XML file


ABC Co
N2345 Lane
NJ-23456


customer address city
ABC Co 123 Main Salem


Thanks and Regards
NimishK

 

[sandy666]

maybe use PowerQuery
Import XML then transform to format what you want to achieve

 

[NimishK]

Thanks Sandy. Installed PowerQuery and tried . Amazing Indeed power of Get and Transform

 

[sandy666]

You are welcome
Have a nice day