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

[Emil_Kos]

Hi @Mildman,

You need the text to columns tool. Please find my workflow attached for reference.

Just to let you know there is an option there to split the data by rows. When you will use it magic will happen 😀

[atcodedog05 · Accepted solution]

Hi @Mildman 

Configure text to column tool like below highlighted.

Workflow:

Hope this helps : )