Hi all,

I have many rows, each of which has a cell with a list of names, each separated by comma. I want to create a separate row for EACH name that is in each cell. For example:

Before:

Col A | Col B
Green | Joe,Bob,Alex
Blue | Joe,Bob
Red | Bob,Alex

After:

Col A | Col B
Green | Joe
Green | Bob
Green | Alex
Blue | Joe
Blue | Bob
Red | Bob
Red | Alex

I've managed to create a macro which will copy a row the appropriate number of times based on the number of names that appear, but I need a bit of help with the next part, which is transposing the names down those columns. I'd rather not use the transpose excel feature, simply because I have so many entries and I'm sure I would make an error somewhere along the way.

Any suggestions are greatly appreciated. Thanks,
J