It's like this as sample

Rec Field1 Field2
1 abc address1
2 abc address2
3 abc address3
4 def address1
5. def address2

Result shall be

1. abc address1, address2, address3
2. def address1, address2


Hope I have made it clear enough

Thanks in advance