Hi, I hv an excel file which contain 2 colums, the first column is STATE and 2nd column is zipcode. The 2nd column contain a list of zipecodes seperated by ",".
My question : how do I separet each of the zipcode and copy it along with column 1 to another worksheet in the same w/book?

Eg : the source file =

state1 | 5500, 5511, 5522
state2 | 6300, 6800
state3 | 45000
state4 |
state5 | 4100, 4200

the expected file =

state1 | 5500
state1 | 5511
state1 | 5522
state2 | 6300
state2 | 6800
state3 | 45000
state4 |
state5 | 4100
state5 | 4200

Thanks in advance.