0

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?

fixer1234
  • 28,064
Excelnoob
  • 1

1 Answers1

1

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.

http://office.microsoft.com/en-au/excel-help/merge-queries-HA104149757.aspx?CTT=5&origin=HA103993872

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.

Mike Honey
  • 2,632