Create a consolidate data table from six large excel files

Project to merge the data from six excel files based on the specifications provided to create a single result file. The result file can be excel (.xlsx) or CSV. Each data excel file has column titles that the “Leg Files Consolidation project” file describes how the data in the columns are to merged into the columns in the result file. One excel file is the primary table that contains columns to look up values in the other files. Thus the result file will contain the same number rows as the primary table. Not all lookups will find a value in the other tables, leave a blank value. A program outside of excel maybe needed. A review of the result file will be done, any errors will result in a fix in your algorithm and a rerun of the merge. The primary data file contain about 64,000 rows.

Attached are the “Leg Files Consolidation [url removed, login to view]” file and “[url removed, login to view]” which contains the layout of the results file. The data file will be available from download from Dropbox or Google drive.

Same project just uploaded a better specification document. Replace "Leg extraction map.xlsx" with "Leg Files Consolidation project.xlxs" as described in the original proposal.

Habilidades: Processamento de dados, Excel

Veja mais: no data was consolidated, source reference overlaps destination area, how to consolidate data in excel from multiple worksheets, cannot create links to consolidation sheet, how to consolidate data in excel 2013, excel consolidate rows and sum data, excel consolidate function, consolidate duplicates in excel, Create automatically Excel Table from data, create html table raw data column excel, can create excel pivot table quickbooks data, excel convert pivot table raw data, consolidate contacts excel, consolidate vcard file, consolidate vcard, script consolidate csv files, consolidate data, consolidate csv, php consolidate css, zynga facebook poker consolidate accounts

Acerca do Empregador:
( 51 comentários ) Montreal, Canada

ID do Projeto: #14489931

Concedido a:


Quick Delivery I can provide.. i have 7 years of experience. No Agency, No middle man. I am direct developer. You can see my profile for client reviews. Relevant Skills and Experience Excel, VBA, MIS Management. Mais

$98 USD em 1 dia
(34 Comentários)

29 freelancers estão ofertando em média $157 para esse trabalho


Let me know if you would like start now Stay tuned, I'm is still working on this proposal.

$200 USD in 2 dias
(253 Comentários)

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Mais

$150 USD em 1 dia
(224 Comentários)

Hello, I am ready to merge the data from six excel files to a single result file and the result file can be excel (.xlsx) or CSV. LETS DISCUSS BEFORE STARTING THE TASK. We assure you for Highest standards of Mais

$200 USD in 4 dias
(153 Comentários)

Hello JONATHAN, I have checked the "Leg Files Consolidation project [login to view URL]" file and other attached files and understood your requirement. I have done similar work in last week. Check our reviews to confirm our work Mais

$75 USD in 2 dias
(281 Comentários)

I am an excel expert. Read the project specs. Looks like this project is feasible. Just want to understand and make sure some of the requirements kindly open PM to discuss work and budget..I am based in california Mais

$200 USD in 3 dias
(155 Comentários)

Hi: I understand that you want to merge 6 files based on a primary file. I have reviewed the documents, it would be great if you could share the sample of 6 files. I can develop the program in Python. Relevant Skills Mais

$150 USD in 5 dias
(157 Comentários)

Hello, Thanks for the opportunity to bid on this project. Task is 100% clear and i will get this done for you. We promise you 100% quality within the time limits. Relevant Skills and Experience Data Processing, Excel Mais

$55 USD em 1 dia
(131 Comentários)

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Nex Mais

$120 USD em 1 dia
(143 Comentários)

I am extremely good with Excel. I am fast accurate and at the same time understand the value of quality and deadlines. I have already done 100 works on where majority of the works I got all 5 star rating Mais

$100 USD em 1 dia
(113 Comentários)

Hi, i am interested in your project. Relevant Skills and Experience Excel Proposed Milestones $100 USD - initial

$100 USD in 3 dias
(54 Comentários)

My approach offers a macro with the usual Open file dialog to identify the current input and output files and and other controls if necessary. Relevant Skills and Experience I have a university degree in economics and Mais

$166 USD in 0 dias
(62 Comentários)
$200 USD in 3 dias
(48 Comentários)

I will import to MS Access, build algorithm within that platform, merge, test and extract to CSV. Relevant Skills and Experience I work in Excel, VBA, Access, VB.Net, Regular Expressions. I have done many merges, s Mais

$222 USD em 1 dia
(14 Comentários)

Greetings Hope you are doing well. I am a CPA (CA/ACCA) Finalist and I provide a range of services, majorly focusing on excel, accounting, financial management, cost accounting and other allied subjects. I have been w Mais

$55 USD em 1 dia
(24 Comentários)

merging the data in the excel Relevant Skills and Experience My core expertise is in excel, data processing projects. Follows instruction and do pay close attention to details. Proposed Milestones $100 USD - excel $1 Mais

$200 USD in 3 dias
(5 Comentários)

Hi, I have read your project description and I understood all your point. I have master degree academic qualification and currently pursuing my PhD. I am well versed with all parameters of your project. I want to assur Mais

$77 USD em 1 dia
(3 Comentários)
$150 USD in 3 dias
(10 Comentários)
$155 USD in 3 dias
(3 Comentários)

MD. SHERAZUL ISLAM Hellow, Dear Honorable Project Manager, I am Md. Sherazul Islam. I have been working as a Data Entry professional as well as SMM provider. But, now I am working as a Team membaer. They are Mais

$30 USD em 1 dia
(8 Comentários)

Hi, We are extremely dedicated and professional freelancing team. We will complete all our project works within budget and time duration. We are expert in all types of Manual Data Entry and Data Processing Work, Pro Mais

$147 USD in 5 dias
(3 Comentários)