Merging Data from Separate Tables

Hi all,

I have multiple data tables in which I want to combine into one table. However, some tables have replicate names, and I want to combine those names into one cell with the sum of the values from all the tables.

Perhaps the graphic below will explain it better...trying to the get to the table named "Final" from the other two tables.

Is there any way to do this? I have looked at this guide but am stuck: http://www.exceluser.com/explore/msquery1_4.htm


Please keep in mind that I have more than two tables, and the graphic below is just a simple example.

Finally, I do not have Microsoft Access, and am using Microsoft Query in Excel. Was told to post my question here.



Thanks to anyone that can help!

Are all the columns in both tables named the same? If so, append all the data from Table 1 and Table 2 to another Table. Create a make table query based on the new table where you sum the points column. When you run the query it should create a table totaling your points column based on the unique data from name column.

Here is the SQL statement for the query.

SELECT JoinedTables.Name, Sum(JoinedTables.Points) AS SumOfPoints INTO Combined
FROM JoinedTables
GROUP BY JoinedTables.Name;

JoinedTables is the table where you placed the data from both tables. Combined is the new table.