I have a dataset that have one id and multiple block and street names.I need to place together all the blocks and street names of an id together by concatenating separated by a comma. The dataset looks like this. ID block street name Ttk1 104A John's street 104B John's street Ttk2 614 Mary street 615 Mary street 616 Mary street 617 Mary street 618 Mary street Ttk3 415 Brooklyn street Ttk4 202 Nashville street 203 Nashville street The final dataset should look like this. Ttk1 104A John's street,104B John's street Ttk2 614 Mary street,615 Mary street,616 Mary street, 617 Mary street,618 Mary street Ttk3 415 Brooklyn street Ttk4 202 Nashville street,203 Nashville street I have tried CATX but couldn't get these results. Any sugestions on how this can be achieved? ... View more