Data CSV Sorting Program
$30-250 USD
Paid on delivery
Hello, I need help with an excel sheet that I use for my sales leads.
The problem is that I sometimes have more than 1 phone number for each lead.
Sometimes a lead can have 3-5 phone numbers.
However each number is always listed on a separate line on my original excel sheet.
I need all of the phone numbers for each lead on the same line. Please reference the Host field for the similarity among the leads.
Please see example attached files with what my file currently looks like and what it needs to look like.
I need to be able to use this file or program to run the same process for many leads.
I need to do this in excel or a php program that would allow me to export a .csv I can later use in excel.
I need to be able to import a list of leads in the incorrect format like the example attached.
Please keep in mind I will use this program to process thousands of leads, possibly even as many as 25,000 - 50,000 at one time.
Your help is appreciated.
Project ID: #1502303
About the project
Awarded to:
9 freelancers are bidding on average $108 for this job
hi. i can build you a php script that will import the excel file(as CSV) inn the wrong format, process it and export it as csv in the right format
Hi, I am interested and ready to help you. Please check pmb for my solution. Thanks, Steve
Hello, I can help you with this job. I done recently something like this on another project. Regards, DoTeam