I have a worksheet with 9000+ rows and 75 columns with many duplicate entries, containing many incomplete cells.
Example:
Joe Smith 111-11-1111 FL ________
Joe Smith 111-11-1111 __ Purchase
Joe Smith ___________ FL Refinance
I would like to consolidate this duplicated entry to one (1) complete entry and delete the duplicates.
Result:
Joe Smith 111-11-1111 FL Purchase
Joe Smith 111-11-1111 FL Refinance
Basically, I would like blank cells in a given row to be populated with like rows' cell data. Then I can delete duplicates. Is there a better method? Please keep in mind that this sheet is huge, 9000 x 75.
Thank you.
Example:
Joe Smith 111-11-1111 FL ________
Joe Smith 111-11-1111 __ Purchase
Joe Smith ___________ FL Refinance
I would like to consolidate this duplicated entry to one (1) complete entry and delete the duplicates.
Result:
Joe Smith 111-11-1111 FL Purchase
Joe Smith 111-11-1111 FL Refinance
Basically, I would like blank cells in a given row to be populated with like rows' cell data. Then I can delete duplicates. Is there a better method? Please keep in mind that this sheet is huge, 9000 x 75.
Thank you.
