I have an excel worksheet with 20,000 dissimilar book isbn, one isbn for each cell. Out of the20,000 here are about 5,000 or10,000 duplicates with varies qtys. Is there a method to merge the duplicate isbn and qty to a particular cell without having to do it physically. In column A I have all the isbn and Column B the qty.
Bookmarks