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.