I'm looking to change multiple companies to the owners name instead. The script can work based on the entire row or we could specify the exact column.
I'm looking to do something like this;
if "Home Values" change to "Smith, John"
if "Costco" change to "Jackson, Michael"