I have a problem I've been dealing with for weeks and I've came up with a VBA work-around, but I'd like to do it in PQ. I have two worksheets that get loaded into two different tables. They will always have the same number of rows and columns. The first row contains week-ending dates and the first column contains part numbers. Cell A1 always contains the text "Part Number". Here is what I'm trying to accomplish. I want to sum the data cell values (Table1B2+Table2B2, Table1C2+Table2C2, etc) into a third table. I've tried combinations of merging and appending and grouping, but I can't get it to work. Maybe I've been trying to hard and need a fresh set of eyes.
Add an index column to both tables, and use those columns as the key to append the tables. You will have to use the Group By option, to aggregate data by the same Index key column.
