Home

Inner Join Excel Files - Detailed Version

File 1: All of file one's contents will be copied to the new file

Excel sheet from file to be read. First sheet is 1.
Locatio of the primary key column. Column A = 1
Starting row in which data will be read.
Starting column in which data will be read.

File 2: Data will be copied to file 1 when there is a primary key match.

Excel sheet from file to be read. First sheet is 1.
Locatio of the primary key column. Column A = 1
Starting row in which data will be read.
Starting column in which data will be read.
The qty of columns to copy from file 2 to file 1.

Images shown below illustrate how to combine two excel files.

Example File 1: Part Shipment Data
Image of an excel file with part numbers and quantities shipped during different time frames indicated by columnn headers.
Fig 1 - Excel report with part numbers representing a product and the quanty of them shipped during time perior specified by the column header.
Example File 2: New Part Shipment Data
Image of an excel file with part numbers and quantities shipped during different time frames indicated by columnn headers. The dates are newer than file 1. Some of the part numbers exist in file 1 and some do not.
Fig 2 - Excel report showing quantities of parts shipped. The data may be pulled from an ERP system and it's column headers represent newer time period than that shown in the first file. Some part numbers in this file 2 exist in file 1 and some are new part numbers.
Example: Parameters To Combine File 1 and 2
Image describing how to set the inputs on the website to combine file 1 and file 2 reflected in the figure 1 and figure 2 respectively.
Fig 3 - Using the first two images as examples, fig 3 shows what inputs to set to combine the files.
Example: File 1 and File 2 Joined
Image of excel report, a result of joining file one (Fig 1) with file two (Fig 2)
Fig 4 - The result of joining File 1 (Fig 1) with File 2 (Fig 2).