Add missing data to cells from duplicates in Excel
Rows 2 to 1925 are related to our current database. We have new records, from row 1786 (the company name column value is Thunkable) to row 4633 which is the end of the sheet. There are duplicates regarding the company name. We want to add records that are not duplicated to our current database (below row 1925) and fill out empty cells in our current database with related data in duplicated records if there are any. To do so, here are the steps:
Start from row 1925. Check the company name. If there is a record with the same value in rows 2-1925, check which cells are empty in that row.
Then for each empty cell check if there is any data in duplicated row and copy it to the cell.
Else, If the company name is not duplicated, add the whole row below the last row of the current database.
Repeat the same for the next row.
246 freelanceria on tarjonnut keskimäärin €113 tähän työhön
Hi There, I have over 5+ years of experience in advance excel. I have understood the task. I am ready to start the work right away. Waiting for your response! Regards, Ujjwal