I am currently exporting a table from a DB in which the information (Marketing Criteria) I want is comma deliminated. I also have another table that is exported to another tab that has a description for each value.

What i am looking to do is to create a third sheet that list out all products and each Marketing Criteria on a seperate line.

ie
Sheet 1
A1 - apple B1 - 1,2,3,4,5

Sheet 2
A1 - 1 B1 - aaa
A2 - 2 B1 - bbb
A3 - 3 B1 - ccc
A4 - 4 B1 - ddd
A5 - 5 B1 - eee

Sheet 3
A1 - apple B1 - aaa
A1 - apple B1 - bbb
A1 - apple B1 - ccc
A1 - apple B1 - ddd
A1 - apple B1 - eee