Find matches in two columns

Question
1

I have two columns, each has a list of customer names. I need to find out what names are in both columns. Any thoughts on how I can do that? or how I can only keep the customer name that are not in both columns? Thanks

2

You can use the Intersect transform.

image
image1178×902 83.9 KB

kim.transform (1.9 KB)

1 Like