delimit and cross tab - all at once.

[xclaim]

would someone please direct me in the right path - i need to accept input like below and always output to 2 columns. thanks you in advance.

<table width="259" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:7131;width:146pt" width="195"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:48pt" height="20" width="64">input1</td> <td style="width:146pt" width="195">input2
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user1</td> <td>group1;group2;group3;group4</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user2</td> <td>group1;group2;group3;group4</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">output1
</td> <td>output2
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user1</td> <td>group1</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user1</td> <td>group2</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user1</td> <td>group3</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user1</td> <td>group4</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user2</td> <td>group1</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user2</td> <td>group2</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user2</td> <td>group3</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user2</td> <td>group4</td> </tr> </tbody></table>

 

[xclaim]

please help

would someone please direct me in the right path - i need to accept input like below and always output to 2 columns. thanks you in advance.

<table border="0" cellpadding="0" cellspacing="0" width="259"><colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:7131;width:146pt" width="195"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td style="height:15.0pt;width:48pt" height="20" width="64">input1</td> <td style="width:146pt" width="195">input2
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user1</td> <td>group1;group2;group3;group4</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user2</td> <td>group1;group2;group3;group4</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">
</td> <td>
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">output1
</td> <td>output2
</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user1</td> <td>group1</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user1</td> <td>group2</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user1</td> <td>group3</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user1</td> <td>group4</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user2</td> <td>group1</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user2</td> <td>group2</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user2</td> <td>group3</td> </tr> <tr style="height:15.0pt" height="20"> <td style="height:15.0pt" height="20">user2</td> <td>group4</td> </tr> </tbody></table>