sorting of data in excel

[rupashree]

hello sir please help me

<table border="0" cellspacing="0" cols="3" frame="VOID" rules="NONE"><tbody><tr><td width="155" align="LEFT" height="17">SPMP906228</td> <td width="109" align="LEFT">SPMP905960</td> <td width="102" align="LEFT">SPMP905960</td> </tr> <tr> <td align="LEFT" height="17">SPMP905960</td> <td align="LEFT">SPMP908349</td> <td align="LEFT">SPMP908349</td> </tr> <tr> <td align="LEFT" height="17">SPMP908349</td> <td align="LEFT">SPMP907370</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">SPMP907370</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">SPMP906327</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> </tbody> </table>
and i need data as mentioned below:

<table border="0" cellspacing="0" cols="3" frame="VOID" rules="NONE"><colgroup><col width="123"><col width="109"><col width="102"></colgroup> <tbody> <tr> <td width="123" align="LEFT" height="17">SPMP906228</td> <td width="109" align="RIGHT">
</td> <td width="102" align="RIGHT">
</td> </tr> <tr> <td align="LEFT" height="17">SPMP905960</td> <td align="LEFT">SPMP905960</td> <td align="LEFT">SPMP905960</td> </tr> <tr> <td align="LEFT" height="17">SPMP908349</td> <td align="LEFT">SPMP908349</td> <td align="LEFT">SPMP908349</td> </tr> <tr> <td align="LEFT" height="17">SPMP907370</td> <td align="LEFT">SPMP907370</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">SPMP906327</td> <td align="LEFT">
</td> <td align="LEFT">
</td></tr></tbody></table>

 

[mikerickson]

Double posting is not effective.
http://www.mrexcel.com/forum/showthread.php?t=557845

 

[rupashree]

Double posting is not effective.
http://www.mrexcel.com/forum/showthread.php?t=557845

ok sorry......can u help me out