I need help on creating dynamic groups on a field called [Account Name]. It contains the names belonging to 2 different companies A and B. I want to group the names which are similar in both A and B companies
Account Name Type
Since there are more than 200000 rows, I cant do it manually. Any help on calculation will be highly appreciated.