Suoritettu

Add missing data to cells from duplicates in Excel

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.

Taidot: Excel, Tiedonsyöttö, Tietojenkäsittely, Visual Basic, Microsoft Access

Tietoa asiakkaasta:
( 104 arvostelua ) Bochum, Germany

Projektin tunnus: #33727580

Myönnetty käyttäjälle:

(216 Arvostelua)
6.6

246 freelanceria on tarjonnut keskimäärin €113 tähän työhön

(354 arvostelua)
8.9
(437 arvostelua)
8.6
(668 arvostelua)
8.4
(1037 arvostelua)
8.3
(1007 arvostelua)
8.4
(363 arvostelua)
8.2
(291 arvostelua)
7.9
(444 arvostelua)
8.1
(490 arvostelua)
7.8
(155 arvostelua)
7.5
(439 arvostelua)
7.6
(330 arvostelua)
7.4
(214 arvostelua)
7.5
ujjwalmalik

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

€100 EUR 1 päivässä
(100 arvostelua)
7.5
(337 arvostelua)
7.2
khushh07

Hello Greetings to you!! I am an Excel (Macro)/Visual Basic and Microsoft Access expert and interested to work with your project. I have checked your requirements and that makes complete sense to me. I assure you of a Lisää

€75 EUR 2 päivässä
(362 arvostelua)
7.4
ZAZwork

Dear Sir, I read your Job description and see that, you are looking for data entry specialist. I can do that in a meaningful way. Best Regards Khadija

€250 EUR 7 päivässä
(148 arvostelua)
7.5
(97 arvostelua)
6.8
(70 arvostelua)
6.9
daniyal3214

I can perfectly assist you with that. I am a professional Excel expert holding years of experience. I will be happy to discuss in detail.

€40 EUR 1 päivässä
(172 arvostelua)
7.1