Grouping long list of records

[thrillhouse]

I am looking to group locations depending on whether the location contains a certain category or not.  It is possible for multiple categories to be represented in a single location.  I am looking to group locations that contain one particular category vs. locations that do not contain that category.  I am probably looking at ~200k in the group but can't seem to figure out a good way to create the group.   Any help is greatly appreciated!  Thanks!

[v-yetao1-msft]

Hi @thrillhouse 

Your need is not clear , can you use a sample to illustrate your source data and the result you want ?

Best Regard

Community Support Team _ Ailsa Tao