Bring Two values in one column using ApplyMap

aamirSiddiquee1 — Mon, 24 May 2021 17:55:42 GMT

My data is

and My Mapping Table is -

Now i want to bring the region value in my data table same as like the country column separated with ';' .

Could you Please suggest any way @sunny_talwar asap.

Thanks

Re: Bring Two values in one column using ApplyMap

jwjackso — Mon, 24 May 2021 22:20:02 GMT

If I understand your need, the MapSubstring() might work.