Grouping in excel Cells with similar words

[Lollino]

Hello to everyone!

Hope you're having a nice day. I am working with on a huge excel file and I wanted to know whether there was a way, using alteryx, to group cells with similar words inside. Like in the picture, 

I would like alteryx to say eg "when I recognize that there are cells similar to Alfa group Spa put in the near cell A", when there are names similar to Beta Spa put near B and so on. 

The reason behind this is that many companies having similar names are part of the same holdings so I have to count how many of them we have in our db without taking into consideration each single subsidiaries.

I hope I explained clearly what I am trying to achieve and hope this thread could help someone else as well.

Thanks in advance!

[mceleavey]

Hi @Lollino ,

this is a good use of the Find and Replace tool, but only if your mock data is representative.

I've built this using the key word to provide the group:

I've attached the workflow.

Hope this helps.

M.