Re: Regrouping XML Data

Dear Friends

I have the following XML data
       <row>
            <col>
                <data>
                    Surveyor
                </data>
                <data>
                    Excavation
                </data>
                <data>
                    Plumber
                </data>
            </col>
            <col>
                <data>
                    11/02/2000
                </data>
                <data>
                    15/02/2000
                </data>
                <data>
                    11/03/2000
                </data>
            </col>
       </row>

I am having difficulty transforming this into:

       <row>
            <col>
                <data>
                    Surveyor
                </data>
                <data>
                    11/02/2000
                </data>
            </col>
            <col>
                <data>
                    Excavation
                </data>
                <data>
                    15/02/2000
                </data>
            </col>
            <col>
                <data>
                    Plumber
                </data>
                <data>
                    11/03/2000
                </data>
            </col>
       </row>

Each <row> has a fixed number of <col>
Each <col> has one set of <data> (this set is variable)
The <data> sets are equal for all <col> in each <row>

Any help is appreciated

That's table transposition, I think:
  <xsl:template match="row">
    <row>
      <xsl:for-each select="col[1]/data">
        <xsl:variable name="nr" select="position()"/>
        <col>
          <xsl:for-each select="../../col">
            <xsl:copy-of select="data[$nr]"/>
          </xsl:for-each>
        </col>
      </xsl:for-each>
    </row>
  </xsl:template>