Hi all,
In my data input, I have two rows of columns that are similar to each other. [Account Name] being the reference column and [Organization] column that I am trying to manipulate. I want to replace the words in the [Organization] column with the true naming convention column, [Account Name].
I am not sure of the workflow on how to achieve this? Fuzzy Match or Find and Replace?
Input
| Organization | Account Name |
| Desert Oasis Health Care | Telecare Corporation |
| Telecare | Desert Oasis Healthcare |
| AAA of Tidewater | Riverside County Office of Education-Corona Norco USD |
| Riverside County Office of Education-Palm Springs USD | AAA Tidewater Virginia |
| Riverside County Office of Education-Corona Norco Unified School District | AAA Texas |
| AAA of Texas | Riverside County Office of Education (RCOE)-Palm Springs USD |
Desired Row Output
| Organization |
| Desert Oasis Healthcare |
| Telecare Corporation |
| AAA Tidewater Virginia |
| Riverside County Office of Education (RCOE)-Palm Springs USD |
| Riverside County Office of Education-Corona Norco USD |
| AAA Texas |
