How do I concatenate strings in one column based on the value in a second column?

Question

Hi, here is a sample table:

Feature:         Owner:

Cravat            Barry

Pudding         Levon

Disco             Barry

Oregano        Doug

240                Levon

OuttaHere     Doug

Dip                Louie

I want to concatenate the strings in the Feature column based on the value in the Owner column, to get this:

Barry            CravatDisco

Levon           Pudding240

Doug            OreganoOuttaHere

Louie            Dip

How do I do this?  I have been studying joins and crosstabs and transpose tools, but I can't seem to wrap my head around it.

Felipe_Ribeir0 · Accepted Answer

Hi @SergeantJack

Just use the summarize with concatenate config.

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.