Split CSV field into Columns

Mildman

I have a set of data that contains IP address in 2 columns.  Some countries contain more IP's than others, i.e.

County  IP addresses

UK        192.168.0.1,192.168.1.1,192.168.2.1,192.168.3.1

IE          193.168.0.1,193.168.1.1

How can I convert the data into 2 columns as the number of IP address in the csv field will vary from1 to 30+, e.g.

Country  IP Address

UK 192.168.0.1

UK 192.168.1.1

UK 192.168.2.1

UK 192.168.3.1

IE  193.168.0.1

IE  193.168.1.1

atcodedog05

Hi @Mildman 

Configure text to column tool like below highlighted.

Workflow:

Hope this helps : )

Ips.yxmd