How to merge data from other Excel files to one master Excel worksheet

microsoft excelmicrosoft-excel-2013worksheet-function

I have an uniform ID system throughout all the files, except with multiple entries and differing data named columns. I would like to create a master excel sheet with specific data columns from each excel file. How does one go about doing this?

Best Answer

I would use the Power Query Add-In. I would import the data from each Excel files into separate Queries, use the "Merge" command to join them together, probably using your common ID column.

Power Query has lots of other data-massaging features that might come in handy along the way.

I would drop the final Query result (only) into an Excel table.

Related Question