I am calculating some metrics and need to standardize Country names on all sides in order to calculate it on a country level.

I have a transaction file consisting of two sql queries and external excel file.
Country 1 Column – First SQL
Country 2 Column – Second SQL
Country Combined Column – Calculated field
Country Excel Column – Excel Column

The Country Combined was made by:

    IF [data (TI)] = [data (PI)] THEN
    [hotel_country (TI)]  // or [hotel_country (PI)] since they are the same
ELSEIF NOT ISNULL([data (TI)]) THEN
    [hotel_country (TI)]
ELSE
    [hotel_country (PI)]
END

What I need to do is match Country Combined to Country Excel columns in order to country level calculations.