Splitting Records Based On Concatenated Strings

Hello all

I have a table containing the following fields:
Customer ID
Customer Name
Countries
The ID is numeric, the name is a string and the countries are the tricky bit since it contains a string of concatenated 2 digit ISO codes: "USCAGB".

What I would like to do is convert the concatenated representation to a normalized one. Take this example table:

ID Name Countries
2 John SEDK
3 Maria USCAGB

From the above table I would like to create a new table that links Customer IDs to single countries as

ID Name Countries
2 John SE
2 John DK
3 Maria US
3 Maria CA
3 Maria GB

How would I go about solving this?