I have a 5-column and 2000+ row table ("Original") with multiple duplicates. I am able to determine those duplicates and erase them putting them in another table ("Original w/o duplicates") but the "Joint" column needs to be renumbered and also the information below the blank rows to be moved up so it continues the sequence (see table "Filtered"). I really would appreciate the help to use a formula to do this, also any other suggestions are welcome. Thanks a lot!
Bookmarks