Grouping based on text field values

I have a list of companies in my data model (fake company names used in this example). In our industry these are grouped in certain ways. Unfortunately this data in not in our data model. I've been g...