Create Duplicate Rows for multiple values in a Column.

[mac2982]

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

[Olly]

Try this:

Please Login or Register  to view this content.

[mac2982]

The only problem with this for me is if I have cells that appear after Column B they do not get duplicated. Wondering how I would solve that?

Thanks!

[xladept]

Hi Mac,

Welcome to the Forum

Just add one line to ollies code as the red code below:

Please Login or Register  to view this content.

[xladept]

Thanks for the rep!