How to merge multiple datarows within a single dataset

[Guest]

Hello all,

I wonder how to merge multiple datarows within one single dataset? I have a
dataset which contains one table, in this table, for example, there are 10
records, where rec#1 - 5 have the same content in column(0) and rec#6-10 have
the same content in column(0), now I want to concatenate another column(1)
for records that have same content in column(0). that is, the new dataset
should have only two record: rec1's column(1) contains the text from previous
rec1-5, and rec2's contains previous rec6-10

Can anyone tell me how to do it? I believe there should be a simple way.

Thanks in advance.

 

[AMDRIT]

You will have to loop over each row and apply your logic.