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

[SergeantJack]

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 solution]

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.

[SergeantJack]

Jeez, that's embarassing.  I should have known that, but I just couldn't seem to think my way through it.  Thanks again!