Filtering for where one column has multiple entries in another column

Question

I have an extract as follows. I want to filter my extract for entries where one supplier has multiple G/L accounts. How would I get go about doing this? At first I thought of combining the the strings in Supplier and G/L Account together and then using the unique tool, but can't think of the solution (e.g. what if there are multiple entries where the wrong account was used)

Extract

Journal Entry #AmountSupplierGL Account1$100Microsoft1232$150Apple1273$200Microsoft2344$100Google2355$50Google9006$75Apple127

Output Expected

Journal Entry #AmountSupplierGL Account1$100Microsoft1233$200Microsoft2344$100Google2355$50Google900

Cremo · Accepted Answer

Hi @Robotomation

You can try the attached workflow. It basically counts the distinct GL account for each supplier and exclude those having only one distinct account (Apple in your example). Let me know if it helps.