Performing queries between one or more excel files
Budget: $10 – $25 USD
Performing queries between one or more excel files.
Hi everyone,
I need some help to perform some query using Excel or GoogleSpreadsheet.
Let me explain the problem:
I've got 1 excel file that contain "Company Name", "Company Website" & "Email" (plus other columns not really relevant).
Some companies has got empties values in "Email" field.
So I've used a software to perform a scraping activity.
Basically the software navigate each links and search for email fields.
The output is a new file excel that contain "Company Website" and "Email".
In Total I've got 18 raw excel files plus 18 excel files given from Scraping software.
The goal is to compare/lookup "Company website" from excel file A with "Company Website" from excel file B, If the values are the same we must copy "Email" values from excel file B and append it into excel file A in the correct row.
Check attached examples files
Please ping me for futher info, we can start an Anydesk session in order to show you what is the result I expect.
Thanks everyone for your kindly attention
Hi everyone,
I need some help to perform some query using Excel or GoogleSpreadsheet.
Let me explain the problem:
I've got 1 excel file that contain "Company Name", "Company Website" & "Email" (plus other columns not really relevant).
Some companies has got empties values in "Email" field.
So I've used a software to perform a scraping activity.
Basically the software navigate each links and search for email fields.
The output is a new file excel that contain "Company Website" and "Email".
In Total I've got 18 raw excel files plus 18 excel files given from Scraping software.
The goal is to compare/lookup "Company website" from excel file A with "Company Website" from excel file B, If the values are the same we must copy "Email" values from excel file B and append it into excel file A in the correct row.
Check attached examples files
Please ping me for futher info, we can start an Anydesk session in order to show you what is the result I expect.
Thanks everyone for your kindly attention