Færdiggjort

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.

Evner: Excel, Dataindførsel, Databehandling, Visual Basic, Microsoft Access

Om klienten:
( 104 bedømmelser ) Bochum, Germany

Projekt ID: #33727580

Tildelt til:

(216 bedømmelser)
6.6

246 freelancere byder i gennemsnit €113 timen for dette job

(354 bedømmelser)
8.9
(437 bedømmelser)
8.6
(668 bedømmelser)
8.4
(1037 bedømmelser)
8.3
(1007 bedømmelser)
8.4
(363 bedømmelser)
8.2
(291 bedømmelser)
7.9
(444 bedømmelser)
8.1
(490 bedømmelser)
7.8
(155 bedømmelser)
7.5
(439 bedømmelser)
7.6
(330 bedømmelser)
7.4
(214 bedømmelser)
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 på 1 dag
(100 bedømmelser)
7.5
(337 bedømmelser)
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 Flere

€75 EUR in 2 dage
(362 bedømmelser)
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 in 7 dage
(148 bedømmelser)
7.5
(97 bedømmelser)
6.8
(70 bedømmelser)
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 på 1 dag
(172 bedømmelser)
7.1