I need a macro to use with excel. Ideally it should work within excel (a macro), but if it is a standalone script/application I will also consider it.
The data I have, looks like this (the list will have up to 20 000 rows) -
column 1(URLs) column 2 (emails)
[login to view URL] name1(at)[login to view URL]
[login to view URL] name2(at)[login to view URL],name3(at)[login to view URL]
[login to view URL] name3(at)[login to view URL],name4(at)[login to view URL],name5(at)[login to view URL]
[login to view URL] name4(at)[login to view URL]
TERMINATE
The first column contains urls. The second column contains emails - one, two or three emails per row, separated by commas. The macro should go through the list and reorganize the list to have one email per corresponding url. The end of the list will be indicated by the word TERMINATE in the first column.
The data above will look like this after the macro has been applied.
column 1(URLs) column 2 (emails)
[login to view URL] name1(at)[login to view URL]
[login to view URL] name2(at)[login to view URL]
[login to view URL] name3(at)[login to view URL]
[login to view URL] name3(at)[login to view URL]
[login to view URL] name4(at)[login to view URL]
[login to view URL] name5(at)[login to view URL]
[login to view URL] name4(at)[login to view URL]
Thanks.