This is one of the common problem across many industries. You can create a mapping table as long as Cust ID is same for the two different common name. I see from your screenshot, though the name is different, the Cust ID is same.
So please find the steps here How to Rename Fields using Mapping Table to solve this issue.
This is the way we can replace the name :
mapping load * inline [
mapsubstring('map1',SalesOrder_Text) as Changed
(ooxml, embedded labels, table is Sheet1);
Here as your requirement you can change as below replace(
AT MECHATRONICS PTE LTD, 'AT MECHATRONICS PTE LTD'
AT MECHATRONICS P L, 'AT MECHATRONICS PTE LTD'