How to combine data into one cell

[clarrock]

Hi,

I want to combine data in column Asset into one record

Eg heres my input data : 

Code	Name	Ccy	Asset
280	Alex	EUR	Govt-Spain
280	Alex	EUR	Govt-Italy
290	Peter	GBP	Cash-EUR
302	Keith	USD	Cash-EUR
438	Adam	INR	Govt-United States
438	Adam	INR	Govt-United States

My expected output creates a unique row for each code
Expected output :

Code	Name	Ccy	Asset
280	Alex	EUR	Govt-Spain, Govt-Italy
290	Peter	GBP	Cash-EUR
302	Keith	USD	Cash-EUR
438	Adam	INR	Govt-United States, Govt-United States

Is this possible?

[binuacs]

@clarrock  Use the summarize tool group by code, name and city, for the asset field select string - concat option

[gawa]

hi @clarrock 

You can use Summarize tool like this. By the way, your sample data has duplicated records (row5&6). If you need to remove the duplicated row, put Unique tool before Summarize tool, if this better fits to your case.