Excel: Change horizontal list to vertical list (imagine a layered transpose)

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,

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of August 22, 2014.

For more resources for Microsoft Excel