Sort by If Contains?

Question

Hi everyone,

I'm trying to sort my data by if the email address contains a company's name or not. But the Sort tool doesn't really work for that and I'm not looking to filter it out either. I want all the data to stay together just sorted so end users can see internal vs external clients in the reports more easily.

In the example below I'd like the Internal email addresses to be sorted by if it contains "Internal" and be on top of the other emails that don't contain "Internal".

Original Data

First NameLast NameEmailAbeLincolnAbe.Lincoln@Internal.comJaneDoeJane.doe@External.comJohnSmithJohn.Smith@Internal.comTomJeffersonTom.Jefferson@External.com

Desired Result

First NameLast NameEmailAbeLincolnAbe.Lincoln@Internal.comJohnSmithJohn.Smith@Internal.comJaneDoeJane.doe@External.comTomJeffersonTom.Jefferson@External.com

Thanks!

DataNath · Accepted Answer

Would this work @jwlam? Just creates a flag where internal is lower than external and so when you sort ascending on the flag they'll all sit at the top. I can't think of any way to do the contains check and sort in one.