-1

I've been trying to figure out a way to combine data from multiple tables into one pivot table. The data from the table is populated when certain information is copy and pasted from a system that we use in my business for multiple lines of production. The report I'm making for this will have multiple people putting in information to the tables (uniformly formatted though) so all of the computations need to be done on the back end.

How do I merge two tables in Excel that have identical columns? <-- the pure excel solution in the bottom of this post is the best solution I've seen for my issue, but I have no idea how to format it or implement it for what I need. Specifically I have 32 named tables that I will be aggregated the data from, and my idea was to create 1 table in which the information from all of the tables is put together, and then to have a pivot table to organize the information from the summary table.

Any help or advice on this would be greatly appreciated!!!

Community
  • 1
Ponathjd
  • 1

1 Answers1

0

I would use Power Query for this. Power Query is a free Add-In from Microsoft for Excel 2010 and 2013, and is built into Excel 2016 on the Data ribbon, under Get & Transform.

Power Query can append data from Excel tables or named ranges. It will automatically line up data from different sources under consistent column headings. It can deliver the result to an Excel Table or directly into the Excel Data Model (Power Pivot), which can feed your Pivot Table with greater power and flexibility.

Mike Honey
  • 2,632