Thank you for your immense support & help.
I am stuck at this issue where I have a dataset with first 2 columns like mentioned below & need Compiled_Jurisdictions column with the help of mapping data given below:
|1013668__HBCZA||CA,ON,BC||Canada, Ontario, British Columbia|
I have a Jurisdiction mapping file as well which is:
|Value in Now|
|PE||Prince Edward Island|
|NL||Newfoundland and Labrador|
so, how to solve this problem as i tried Find & replace tool but it's not compiling various jurisdiction in a single row.
Thank you in advance