Hi All,
I am having a real hard time trying to explain what am actually trying to do as result so I have tried to demo it below.
I need to change this
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
into this
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
And I dont know the best way to do it (or if it is actually possible).
There are around 15,000 records with about 30% of them being duplicates of the ref (a maximum of 11 duplicates) but the reult can be any number. Any advise would be very welcomed.
I am having a real hard time trying to explain what am actually trying to do as result so I have tried to demo it below.
I need to change this
Ref | Result |
a123 | 1 |
b123 | 2 |
c123 | 3 |
a123 | 2 |
a123 | 1 |
b123 | 1 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
into this
a123 | 1, 2 ,1 |
b123 | 2, 1 |
c123 | 3 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
And I dont know the best way to do it (or if it is actually possible).
There are around 15,000 records with about 30% of them being duplicates of the ref (a maximum of 11 duplicates) but the reult can be any number. Any advise would be very welcomed.