Summarize Column of Delimited Strings

[Anonymous]

Hi,

I have a column of text delimited by commas and need to count the instance of each delimited string. For example:

Column

abc,xyz

abc,lmn,qrs

xyz,qrs

I know how to split the column by the delimiters, but that doesn't seem to help the situation. I would like to yield a separate table with 2 columns: 1, with each distinct string and 2, the number of instances.

Any help would be appreciated, thanks!

[Vvelarde · Accepted solution]

@Anonymous 

Hi, In Query Editor:

1: Split by Delimeter

2. Unpivot Columns

3. Remove Column  (Attribute)

4. Group By (Values)--Count

Ready