Forum Discussion
How combine two tables from two spreadsheedts by Using integrated PowerPivot
Ciria it's hard to tell what's going on when there's nothing in your screenshot but null values. Do all the columns in table 1 have the same names as all of the columns in table 2? If the columns don't have matching names, Power Query has no way of knowing which column from table 2 is supposed to match up with which column of table 1, so they will be merged as a new set of columns with null values where the two tables overlap.
Here a picture that shows what I said. As you can see, because of the European regulation, we have to provide different codification to the internal batch, based on the product group/family.
If product belongs to Family A, it goes to the first spreedsheet, on the contrary, if it belong to Family B, it goes to the second spreedsheet.
Thanks for your support :-)
Edit Query--Append:
They put your 2do file's rows below the last row of spreadsheet1
Example:
File 1
ID Code
1 A
2 B
3 C
File 2
ID Code
4 D
5 E
6 F
Step 1: Edit QueryStep2: AppendStep 3: Ready