concatenating values into one record

[sanzoo]

Hello guys,

I would need your help with my goal which is as follows. I`m trying to concatenate 2 unique values which are parts of 2 identical rows(records) in order to have only 1 row(record) with concatenated field where the values are unique. For illustration here is what I need to achieve :

Initial table:
Fld1 Fld2 Fld3 Fld4
AAA XXX BBB CCC
AAA YYY BBB CCC

Final Table:
Fld1_____Fld2______Fld3__ Fld4
AAA____XXX,YYY___BBB___CCC


Any idea how this could be achieved ?
Thank you.

 

[John Big Booty]

Perhaps the article here will help you achieve your goal.