Færdiggjort

Merge information in 2 Lists Excel or CSV format

Please before you answer please read through whole this description. To prove that you have done that answer you offer with the last word in this description as your first work.

I need help with someone to merge information from one list to another.

I have a CSV file "List Domains without [url removed, login to view]" with 3 columns:

Domain;URL;Nameserver

I have another one CSV file "List Domains without [url removed, login to view]" whick contains;

Domain;Email

What I need is a script or something that goes through each row in the first list "List Domains without [url removed, login to view]" and then for each domain in that list (column A) goes to list "List Domains without [url removed, login to view]" searches for the same domain and then picks the email for that domain (column B) and adds to the first list (; in between if use CSV format).

Please note that the same domain can be more then one time in list B. So just pick the email from first one.

I dont know is this is best done with script, in excel or whatever. So in you answer please write the way you would solve this.

The price you bid is the price I am going to pay you. Many times I have experienced seller who bid a low price but then when project is awarded they cahnge price. Very timeconsuming and frustrated.

See attched files so you understand better.

Færdigheder: Dataindførsel, Databehandling, Excel

Se mere: combine two lists without duplicates excel, merge data from duplicate rows in excel based on unique column, excel join two lists into one, combine two lists in excel, excel combine multiple lists into one, excel combine lists from multiple sheets, how to merge two excel spreadsheets and remove duplicates, excel combine multiple columns into one list, excel csv format, excel csv format numbers, graph excel csv format problem, changes excel csv format, excel csv format change, csv excel money format, submit information form email address csv format

Om arbejdsgiveren:
( 33 bedømmelser ) Bro, Sweden

Projekt-ID: #16042988

Tildelt til:

TonmoyRoy111

Last word in the description is "better" Dear Client, I can do this task in less than an hour using macro. Please trust me and contact me. $20 is my final price. ($15 for me and $5 as project fee) Thanks Roy

$20 USD på 1 dag
(236 bedømmelser)
6.3

61 freelancers are bidding on average $31 for this job

cgullapalli

Hi, (lastword: better) I am good at converting the data from csv to another csv using 2 approaches, 1) Using additional concatenated column 2) or using array formulas. But, there is a problem with this. when t Mere

$20 USD in 0 dage
(627 bedømmelser)
7.7
nikhil08

Hi there, I have experience of this type of Job. I will take those files to access to run queries & will upload return csv file to you. My quote is $15 for this task.

$15 USD på 1 dag
(183 bedømmelser)
7.5
mirniyazuddin92

Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I can merge information in 2 Lists Excel or CSV format. I can handle this job very well to you Mere

$30 USD på 1 dag
(289 bedømmelser)
7.5
SBITServices

Hello , I have checked the files ,read your project description and understood your requirement. I can write a macro which checks for the corresponding domain of list 1 in the list 2 and then takes the email from list Mere

$25 USD på 1 dag
(297 bedømmelser)
7.2
RSUKANTA2014

Hello, Actually I am not familiar with any script for this but I can do this work manually. I understand this work. And this is a simple copy paste work so I will charge you $25 with the fee. Kind regards, Roy.

$25 USD på 1 dag
(298 bedømmelser)
7.1
nomannaumi

"Frustrated" Hello sir.. I have just seen your project. I am very much interested to work with you on this project. I have 4 years of career and experience of working on freelancer platform with my dedicated team. S Mere

$30 USD på 1 dag
(74 bedømmelser)
6.9
HardWorker1989

Hello. I have the perfect formula that can make it work in Excel and get you the email with correct domains matched up and entered into the next column I have already completed the project. Just send me a message Mere

$30 USD på 1 dag
(96 bedømmelser)
7.0
zolayossa

better Do you want this done only once? Or do you want a script you want to run every now and then? I'm ready to start on this right away and finish in couple of hours. Thanks,

$20 USD på 1 dag
(173 bedømmelser)
6.5
deepabittu

A proposal has not yet been provided

$35 USD på 1 dag
(255 bedømmelser)
6.6
nagyzoltan68

"Better". Hello, I have great experience using excel and macros. I intend to create custom macro, which will find the first correspondence for domain and will extract email. Regards.

$25 USD in 0 dage
(98 bedømmelser)
6.0
suyashdhoot

Hi I am a very experienced statistician and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have d Mere

$250 USD på 1 dag
(36 bedømmelser)
5.9
caabdul

Better not best result guaranteed. Let me do it

$12 USD in 0 dage
(55 bedømmelser)
5.8
tanjirdramatist

Dear Sir, I have read your job description & have understood your all requirement. I have also a big team to complete it earlier. After seeing my previous record, You will decide that I will be the right person for Mere

$30 USD på 1 dag
(140 bedømmelser)
5.7
renesontiongson

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

$30 USD på 1 dag
(68 bedømmelser)
5.3
arman0464

I have 04+ Years experience in this field with 100% of success ratio. Delivering top-level services is my speciality . I believe that my expertise would be a good match for your project. Ready to start. I have compl Mere

$15 USD på 1 dag
(107 bedømmelser)
5.4
Imranatmoon

Hi There, There are two ways to do this. Very very easy and simple I can show you either with screenshots, video, or live Regards Imran

$25 USD på 1 dag
(40 bedømmelser)
5.0
aimefx

Hi, It is easy, working on your files, I will send you the completed listed in 10 minutes. Send me a message in chat so that i can send it in chat. thanks Completed: Please check the screenshots http://prntscr. Mere

$25 USD på 1 dag
(29 bedømmelser)
4.9
$20 USD på 1 dag
(53 bedømmelser)
5.0
vineet370

Hi There, Thanks in advance for the opportunity. I came across your project and would like to work on it. I am a post graduate with a great command over English. I have more than 6+ years of experience in data entr Mere

$25 USD på 1 dag
(57 bedømmelser)
5.2
SShtv

I'm interested in your proposal. Your task is clear to me and I am ready to solve it. This is a screenshot of one of my works. [url removed, login to view]

$10 USD på 1 dag
(42 bedømmelser)
5.2