importing XML into Excel

I am at wits end here.

I am trying to import an XML file into Excel and it isn't working out so well.
Below is a snippet of how the XML looks and attached is an PDF with an image of how the data looks in excel and then how I want it to look.  Is my XML jacked up?

<?xml version="1.0"?>
<root>
<Computer>
<IP>172.20.20.4</IP>
<Serial_Number/>
<Make_Model>Dell Inc. Precision WorkStation T5400</Make_Model>
<Physical_Memory>2.7 Gbytes</Physical_Memory>
<Virtual_Memory>1.3 Gbytes</Virtual_Memory>
<Paging_file>6.6 Gbytes</Paging_file>
<Operating_System>Microsoft Windows 10 Pro</Operating_System>
<Service_Pack/>
<Product_ID>abc</Product_ID>
<IP_Address>
172.20.20.4
<Network_mask>255.255.255.0</Network_mask>
<Default_Gateway>172.20.20.1</Default_Gateway>
<DNS_Address>172.20.20.1</DNS_Address>
<NIC>Broadcom NetXtreme 57xx Gigabit Controller</NIC>
<MAC_address/>
</IP_Address>
<Host_Name>T5400w7</Host_Name>
<Proccessor>Intel(R) Xeon(R) CPU E5420 @ 2.50GHz</Proccessor>
<Proccessor_speed>2494</Proccessor_speed>
<Proccessor>Intel(R) Xeon(R) CPU E5420 @ 2.50GHz</Proccessor>
<Proccessor_speed>2494</Proccessor_speed>
</Computer>

Open in new window

Document1.pdf
LVL 11
chadAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jkpieterseCommented:
Have you tried the options I listed here:
http://jkp-ads.com/Articles/XMLAndExcel00.asp
0
aikimarkCommented:
looks like the XML is malformed.  Try the attached version
Q_28735457.xml
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
chadAuthor Commented:
Thank you Both.  Both helped but I may need follow up.
In my XML sample I wanted a few elements to be childs of the <IP_Address> element so that if a computer has 2 NIC connections it would reflect that in the XLS.  

using aikmark's suggestion I removed those subnested elements and now it works better but will always list one NIC configuration.  Is there a way to expand that from and XML file?

thank you,
0
aikimarkCommented:
post the XML you have in mind
0
chadAuthor Commented:
I have shelved this project for now. I will need to address it again in a year or so. For now I am using a rendition recommended above. Thanks for the support
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.