Hi I have a sheet that looks like this:

Col A | Col B | Col C
-----------------------------------------------------------
Alfred | apple, orange | 1
Frank | apple | 2
Bert | pineapple, apple, orange | 3

I want it to duplicate the rows for each value in the row's Column B cell like so.

Col A | Col B | Col C
-----------------------------------------------------------
Alfred | apple | 1
Alfred | orange | 1
Frank | apple | 2
Bert | pineapple | 3
Bert | apple | 3
Bert | orange | 3

Wondering how to do this via a macro