Crosstab data and put categorical data into one cell separated by a coma

[imadorkous1]

How can I crosstab this sample data, and store the categorical data into one cell separated by comas?

Input

Output:

[DataNath · Accepted solution]

Hey @imadorkous1, one of the String aggregation options we have in the Summarize tool is to concatenate values. If you just Group By [Name] and [CustomerName] and then concatenate the States, you'll arrive at your desired outcome:

[Dina]

I would recommend use Summarize tool. Group by Name and Customer Name, concatenate State.

[imadorkous1]

@DataNath @Dina Thank you so much for the quick reply! and I cant believe I never knew this existed! Appreciate it!! I wish I could accept both solutions!