Create a one to one relationship

I have an entry in col B in the attached spreadsheet. In column C there are multiple rows in a wrapped cell. What I need to do is make a row for each entry in col C that has Col B next to it.

so if you have, xxx in col B

and

aaa
bbb
ccc
ddd
eee

in col C

I would want the following on a new sheet:

xxx aaa
xxx bbb
xxx ccc
xxx ddd
xxx eee

Is there a way to write a macro to do it?

this code should do the trick

Please Login or Register  to view this content.