Exporting XML file

Hi All,

I've created an Excel file from one provided by a client. It now has 23 columns and 1000s of rows. I'm looking to generate a XML file but have limited knowledge.

I made a simple XML schema (attached) which allows me to export the file correctly. In so doing each row becomes a parent (in my case, <item>) of the root (<items>). In this way, all the rows are listed as <item> and are bound at the start and end of the file by <items>.

As I'm using the XML file for a complicated book layout, I now need to group every 10 rows into a parent element. For example:

<items>
<item>1</item>
...
<item>10</item>
</items>
<item>
<item>11</item>
...
<item>20</item>
</items>

I believe this should be easy but I have already wasted hours trying to work it out... I'd appreciate any help!

Thanks