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
Solved! Go to Solution.
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 😀