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.
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.
KHorseman thanks!!
It was what you said, changing the column headers (using the same names in both files), and defining the exact number of columns in both files, Append function worked well :-)
Great job!
Thanks again guys!:smileyvery-happy: