Help with an Xsl Transormation

[George Durzi]

Hi! Can someone help me out with an Xsl transformation? How can I get the
following Html, using the Xml below?
The challenge I'm having here is selecting the unique "KeyDemoValueCW"s, and
them enumerating "KeyDemoCategory", "KeyDemoValueCW", "KeyDemoValueLW",
within the unique "KeyDemoValueCW"'s.

Thanks!

<tr>
<td>Age</td>
<td></td>
<td></td>
</tr>
<tr>
<td>18-24</td>
<td>.12</td>
<td>.17</td>
</tr>
<tr>
<td>25-44</td>
<td>.61</td>
<td>.50</td>
</tr>
<tr>
<td>Sex</td>
<td></td>
<td></td>
</tr>
<tr>
<td>Male</td>
<td>.66</td>
<td>.59</td>
</tr>
<tr>
<td>Female</td>
<td>.34</td>
<td>.41</td>
</tr>

<DataConsistency>
<KeyDemo>
<KeyDemoName>Age</KeyDemoName>
<KeyDemoCategory>18-24</KeyDemoCategory>
<KeyDemoValueCW>.12</KeyDemoValueCW>
<KeyDemoValueLW>.17</KeyDemoValueLW>
</KeyDemo>
<KeyDemo>
<KeyDemoName>Age</KeyDemoName>
<KeyDemoCategory>25-44</KeyDemoCategory>
<KeyDemoValueCW>.61</KeyDemoValueCW>
<KeyDemoValueLW>.50</KeyDemoValueLW>
</KeyDemo>
<KeyDemo>
<KeyDemoName>Sex</KeyDemoName>
<KeyDemoCategory>Male</KeyDemoCategory>
<KeyDemoValueCW>.66</KeyDemoValueCW>
<KeyDemoValueLW>.59</KeyDemoValueLW>
</KeyDemo>
<KeyDemo>
<KeyDemoName>Sex</KeyDemoName>
<KeyDemoCategory>Female</KeyDemoCategory>
<KeyDemoValueCW>.34</KeyDemoValueCW>
<KeyDemoValueLW>.41</KeyDemoValueLW>
</KeyDemo>
</DataConsistency>

 

[George Durzi]

I meant to say

The challenge I'm having here is selecting the unique >> "KeyDemoName"s << ,
and
them enumerating "KeyDemoCategory", "KeyDemoValueCW", "KeyDemoValueLW",
within the unique "KeyDemoValueCW"'s.