There should be a fixed formulated logic to arrive at your required output. If not so, then a lot of formulated logics (permutation and combination can arise).
How do you arrive at 1616, USA? Many questions can arise like is it possible to have 161, USA- 116,USA-16161,USA and so on and so forth.
If the logic is there, then you can use
case when,substring, like etc