XML Data

[Jcraig713]

Is there any way to create a program to turn data I may be viewing as an xml
list in excel, to return a record where all attributes of the record are in
ONE record row. I have an xml file where the data many times is displayed
across several rows in excel. Trying to sort on the data then becomes
extrememly problematic. I would like to view the xml data in excel like I
could when importing a txt file. Is this possible using xml in excel?

 

[jason]

Is there any way to create a program to turn data I may be viewing as an xml
list in excel, to return a record where all attributes of the record are in
ONE record row.  I have an xml file where the data many times is displayed
across several rows in excel.  Trying to sort on the data then becomes
extrememly problematic.  I would like to view the xml data in excel like I
could when importing a txt file.  Is this possible using xml in excel?

try using the SPLIT function with < and > or use MID while looping
through the text.
could you share some sample data?