Hi,

I have some data in Excel that is denormalized. Looks like this:

RowID RowName RowSegID StartX EndX StartY EndY NumSeats
2 1 2.1 0 7.92 0.2 0.2 16
2 1 2.2 9.1593 17.0798 0.2 0.2 16
3 2 3.1 0 7.92 1 1 16
3 2 3.2 9.1593 17.0798 1 1 16
4 3 4.1 0 7.92 1.8 1.8 16
4 3 4.2 9.1593 17.0798 1.8 1.8 16


I need to export it to XML, in a structure like this:

<Rows
<Row id="2" name="1"
<RowSegment id="2.1" startx="0" endx="7.92" starty="0.2" endy="0.2"
numseats="16"/
<RowSegment id="2.2" startx="9.1593" endx="17.0798" starty="0.2"
endy="0.2" numseats="16"/
</Row
<Row id="3" name="2"
<RowSegment id="3.1" startx="0" endx="7.92" starty="0.2" endy="0.2"
numseats="16"/
<RowSegment id="3.2" startx="9.1593" endx="17.0798" starty="0.2"
endy="0.2" numseats="16"/
</Row
<Row id="4" name="2"
<RowSegment id="4.1" startx="0" endx="7.92" starty="0.2" endy="0.2"
numseats="16"/
<RowSegment id="4.2" startx="9.1593" endx="17.0798" starty="0.2"
endy="0.2" numseats="16"/
</Row
</Rows


At the moment, when I try to achieve this using the XML export feature
under the 'Developer XML' button of the ribbon, it does not let me
export. The error message complains because the data contains
denormalized data.

Can anyone tell me if this can be achieved... or do I need to give up
now?

Many thanks,

AT