If this is what you mean, the new table would look like the small table below. First I had a calculated field in the main table based on the Load_Location and Unload_Location, but since the locations in these fields are not always correct, i have made an Excel file that changes the wrong location names into the correct location names.
ShipmentNumber Load_Location_New Unload_Location_New ShipmentLane 385473 AMS MPX AMS - MPX 983483 CDG BRU CDG - BRU 934939 LHR BCN LHR - BCN 394933 BRU LHR BRU - LHR
May be like this:
applymap('ExcelFileLoad',Load_Location,Null()) as Loadlocnew,
applymap('ExcelFileUnload',Unload_Location,Null()) as Unloadlocnew;
Loadlocnew&'_'&Unloadlocnew as ShipmentLane
Drop Table Temp_Main1;