Merge information in 2 Lists Excel or CSV format

$10-30 USD

Completed

Posted

over 6 years ago

$10-30 USD

Paid on delivery

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 [login to view URL]" with 3 columns: Domain;URL;Nameserver I have another one CSV file "List Domains without [login to view URL]" whick contains; Domain;Email What I need is a script or something that goes through each row in the first list "List Domains without [login to view URL]" and then for each domain in that list (column A) goes to list "List Domains without [login to view URL]" 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.

Data Entry

Data Processing

Excel

Project ID: 16042988

About the project

59 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 in 1 day

4.9

(437 reviews)

7.2

59 freelancers are bidding on average $31 USD for this job

@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 your appreciation. I can find and extract the information from different websites into an Excel sheet. I am ready to hear the details of the project more in detail now. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

$30 USD in 1 day

4.9

(425 reviews)

8.1

@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 the number of rows are more, it takes to time to recalculate it. -Chandra

$20 USD in 0 day

5.0

(962 reviews)

8.1

@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 in 1 day

5.0

(255 reviews)

7.8

@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 in 1 day

4.9

(419 reviews)

7.3

@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 you. Now you can justify me and give me a chance to serve you. Best regards Md. Tanjir Hossain

$30 USD in 1 day

5.0

(217 reviews)

7.0

@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. So i am pretty much confident and will try my best to finish the project with full accuracy and satisfaction. I would like to use some excel built in formula to finish the project. Please open a chat session for further discussion. Thanks..

$30 USD in 1 day

4.9

(75 reviews)

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 in 1 day

4.9

(207 reviews)

6.7

@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 day

5.0

(141 reviews)

6.6

@deepabittu

A proposal has not yet been provided

$35 USD in 1 day

4.8

(330 reviews)

7.0

@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 and I will send you a small sample of the large file to show that I have done the task :) Please send me a message to get started. Many thanks Saad

$30 USD in 1 day

4.9

(104 reviews)

7.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 done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, WEKA, TABLEAU and excel tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash

$250 USD in 1 day

4.8

(84 reviews)

6.8

@caabdul

Better not best result guaranteed. Let me do it

$12 USD in 0 day

4.8

(63 reviews)

6.3

@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 in 1 day

4.8

(75 reviews)

5.6

@vano101

Hello. I have checked requirements and it looks pretty easy to complete. Rather, I would prefer to use Python script for this completing project, but it's possible to write Excel VBA script, if you prefer. PS. I never change price. Excepting scope of work was changed significantly.

$21 USD in 1 day

4.9

(58 reviews)

5.2

@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 completed many project and I read your description carefully and understand all your requirements. I am expert Image Editing, Photo Editing, Photo retch, Photo Background removed,transcribe an audio file ,Data Entry, Excel, Web Scraping, Web Search, Yellow page an,d Yelp Web Scraping PDF to excel, PDF to Word, Image to text, Facebook Marketing, Update template I’m astute, creative, and pay attention to detail. Thank you for your consideration.

$15 USD in 1 day

4.7

(110 reviews)

5.5

@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 in 1 day

5.0

(66 reviews)

5.3

@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 entry, data mining & web research work. I can work for up to 40 hours/week and can start work anytime. I will provide you best quality work.

$25 USD in 1 day

4.8

(64 reviews)

5.5

@svsinfopro

I am familiar with excel formulas & indexing. Kindly give a chance to serve you the best from us, & I hope you will like our services.

$15 USD in 1 day

5.0

(8 reviews)

4.8

@teeares

better. I can write a macro in Excel to carry out the task.I have studied both the files. If you message me I will provide a sample for you to check. I will the script to those requirements.

$30 USD in 1 day

4.6

(62 reviews)

5.3

@chintuag

Dear Hiring Manager, I am an expert in Excel and have worked on various automation projects. My skill includes, but not limited to: Macros, Web Scraping, User Forms, Dashboards, Pivot Tables, Customized Ribbon Buttons, Data exchange with external applications (PDF, Outlook, Access), etc, I would be writing a macro to automate this requirement. Looking forward to hear from you. Note: I was unable to understand what answer you are looking for in the 1st paragraph of the project description, hence I haven't mentioned anything in the end. Regards Chintu

$31 USD in 1 day