Delimit and create a loop in VBA for a varible number in each row

[MrPink1986]

Hi there,
I have a data set where in column J and K I have data which is separated by ; - the data which is A-I is relatable to what is in these columns.
I would like to delimit that data in both these columns which will have the same number of data elements in each and then create a line for each element which was delimited and add the data from A-I for each data element and repeat the process for over 8k rows.

In the below example I would like the first line to only contain cat and Mon then a new line created and inserted with all information up to H with god and Tue and finally the process repeated with all information up to H with sheep and Wed. These columns will have a varying number of elements and it wont always be three.

Thaks in advance.

a

b

c

d

e

f

g

h

cat;dog;sheep

Mon,Tue,Wed

 

[MrPink1986]

Yes the last character in each cell contains a ";" - I presume it thinks it needs a new line based on this?

That was the case - the data is now as expected - I added a couple of formulas to the script to trim the data and remove this ";".
Thanks for your help.