Hi,
I have 2 columns (ID, Product Interest) in the below format
A B
0001 A; B; C; D
0002 A; B
0003 D
0004 A; B; D; E
";" is the delimiter
I'm trying to come up with a macro to convert this data into this format:
A B
0001 A
0001 B
0001 C
0001 D
0002 A
0002 B
0003 D
0004 A
0004 B
0004 D
0004 E
I have been trying to get this work all morning but couldn't. Please help!
Thanks,
I have 2 columns (ID, Product Interest) in the below format
A B
0001 A; B; C; D
0002 A; B
0003 D
0004 A; B; D; E
";" is the delimiter
I'm trying to come up with a macro to convert this data into this format:
A B
0001 A
0001 B
0001 C
0001 D
0002 A
0002 B
0003 D
0004 A
0004 B
0004 D
0004 E
I have been trying to get this work all morning but couldn't. Please help!
Thanks,