suppose i have an xml file like:
<Table>
<IO_Body>

    <name> srini</name>
    <name> ramesh</name>
    <name> rama</name>

    <phone>22382</phone>

    <name>krish</name>
    <name>latha</name>
    <name>asha</name>

    <phone>43452</phone>

    <name>kumar</name>
    <name>xxx</name>
    <name>yyy</name>
</IO_Body>
</Table>
here the first 3 names are not having a phone number.
after that for each group phone number is there.

like this some sets may have phone number and some other sets may not have a phone number.

now i have to write an xSl so that the result should be of the form:

<Row>
    <Cell>
        <Data ss:Type="String">srini</Data>
    </Cell>
    <Cell>
        <Data ss:Type="String">ramesh</Data>
    </Cell>
    <Cell>
        <Data ss:Type="String">rama</Data>
    </Cell>
</Row>
<Row>
    <Cell>
        <Data ss:Type="String">22382</Data>
    </Cell>
</Row>
<Row>
    <Cell>
        <Data ss:Type="String">krish</Data>
    </Cell>
    <Cell>
        <Data ss:Type="String">latha</Data>
    </Cell>
    <Cell>
        <Data ss:Type="String">asha</Data>
    </Cell>
</Row>
<Row>
    <Cell>
        <Data ss:Type="String">43452</Data>
    </Cell>
</Row>
<Row>
    <Cell>
        <Data ss:Type="String">kumar</Data>
    </Cell>
    <Cell>
        <Data ss:Type="String">xxx</Data>
    </Cell>
    <Cell>
        <Data ss:Type="String">yyy</Data>
    </Cell>
</Row>

please help me.
srini.




srini

__________________
srini