I have a source and a resultant xml.Can someone provide me with an xslt for this scenario.

Source
-------
<table>
    <tableData>
        <row>
            <a>cat A</a>
            <a>Asomestring1</a>
            <a>Asomeotherstring1</a>
            <b>Asomedata1</b>
            <b>Asomeotherdata1</b>
        </row>

        <row>
            <a>cat B</a>
            <a>Bsomestring1</a>
            <a>Bsomeotherstring1</a>
            <b>Bsomedata1</b>
            <b>Bsomeotherdata1</b>
        </row>

        <row>
            <a>cat A</a>
            <a>Asomestring2</a>
            <a>Asomeotherstring2</a>
            <b>Asomedata2</b>
            <b>Asomeotherdata2</b>
        </row>

        <row>
            <a>cat A</a>
            <a>Asomestring3</a>
            <a>Asomeotherstring3</a>
            <b>Asomedata3</b>
            <b>Asomeotherdata3</b>
        </row>

        <row>
            <a>cat B</a>
            <a>Bsomestring2</a>
            <a>Bsomeotherstring2</a>
            <b>Bsomedata2</b>
            <b>Bsomeotherdata2</b>
        </row>

    </tableData>
</table>


Resultant
------------
<rows>
<row>
<cell>cat A</cell>
<row><cell>Asomestring1</cell><cell>Asomeotherstring1</cell><cell>Asomedata1</cell><cell>Asomeotherdata1</cell></row>
<row><cell>Asomestring2</cell><cell>Asomeotherstring2</cell><cell>Asomedata2</cell><cell>Asomeotherdata2</cell></row>
<row><cell>Asomestring3</cell><cell>Asomeotherstring3</cell><cell>Asomedata3</cell><cell>Asomeotherdata3</cell></row>
<row></row>

</row>

<row>
<cell>cat B</cell>
<row><cell>Bsomestring1</cell><cell>Bsomeotherstring1</cell><cell>Bsomedata1</cell><cell>Bsomeotherdata1</cell></row>
<row><cell>Bsomestring2</cell><cell>Bsomeotherstring2</cell><cell>Bsomedata2</cell><cell>Bsomeotherdata2</cell></row>
</row>

</rows>

As is so often the case with XSLT this is a grouping question.

If you are using XSLT 2.0 then use <xsl:for-each-group>, and if you are using XSLT 1.0 then you need to use the slightly more complicated Muenchian Grouping method: http://www.jenitennison.com/xslt/gro...muenchian.html

Give it a try yourself and then if you are still stuck show us what your XSLT looks like and we'll try to help.

/- Sam Judson : Wrox Technical Editor -/