Unfortunately I have two lists in one workbook, with inconsistently formatted corresponding data in two lists (on one workbook)

When I encounter a mismatch in a column, I need to add rows (for as many occurrences as the duplicate exists... only in part of the sheet which is a pain in the a$$), and then copy and paste that data down until the next item.

Please help; i'm really stumped with this one.

I've recreated an image of what i'm attempting to do.. I hope I make it clear.

More Rose Gillen's questions See All
Similar questions and discussions