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.