Hi all,

What I’m trying to do is use excel to make my life easier, and create an xml file. The problem is my information is stored in columns like this...

<Location> <Ingredient> <Product> <ingredient Number>
1 1 1 1
1 1 2 1
1 2 1 2


I need the final xml file to read

<location1>
<product1>
<Ingredient>
<Ingredient number>
<product2>
<Ingredient>
<Ingredient number>
<location2>

And so on and so forth.

The only thing I’ve managed to do with excel is to export my table of information into this following format

<location1>
<product1>
<Ingredient>
<Ingredient number>
<location1>
<product2>
<ingredient2>
<Ingredient number2>

I can’t seem to get all the corresponding Childs under its appropriate parent, and excel keeps making a new parent even though the parent name is the same.

I’m terrible at explaining things and I understand this may not be entirely clear so let me know if you need any extra clarification.

Thanks so much!