Assign multiple values to XML attribute

Hi,

First off, I hope Im posting in the correct area, I couldnt see a section for XML.

I have an XML file which I create from excel, and all works fine. However, I now need to add two Product sets instead of one, below I have posted what the XML file would look like, minus all the irrelevant info.

The issue I am having is that excel will not let me add the same attribute twice so I wanted to check if there is a way around this, I tried seperating the values with a comma but that made no difference, I have very little experience with XML, so any help at all would be greatly appreciated.

Excel File has the heading like so

name | product_set

but will not allow me have

name | product_set | product_set

Please Login or Register  to view this content.

Thanks

PS, if there is any other info I can provide to make it easier to understand the issue, please let me know.