How to Convert Rows to comma separated values
<div class="jive-message-body"><pre class="jive-pre">
COLNUM COLDATE COLNAME COLWT COLNAME
1 6/13/2011 Light 1150 Kg Name1
2 6/13/2011 Extra Light 900 Kg Name1
</pre></div>
output needed
<div class="jive-message-body"><pre class="jive-pre">
COLNUM COLNAME COLWT
1, 2 Light, Extra Light 1150 Kg, 900 Kg
</pre></div>
COLDATE and COLNAME will be unique.
I don't want use cursor or any loop logic.