Forum Discussion
Solved
Combine columns from different tables
Hello, Newbie here. I know others have posted similar questions, but couldn't find a way to do mine. So I have two tables: Table 1 ID Collection Date species Latitude Longitude Test...
Rename the Column Head of both table, and make sure that the two are equal.
IN powerquery select the most recent table, and then "Apend New Queries"
rafaelmpsantos
Responsive Resident
Responsive ResidentThese 2 tables has the same numbers of rows? in each row number of tableA you have in tableB the correspondent value in the same row?
They have different rows. Table 1 has 2000 plus rows and Table 2 has about 300 rows. They are totally different set of data and are not related in anyway. Table 1 is from a very old database and Table 2 is a newer one. We just need to put them together. Thanks.
- rafaelmpsantos
Rename the Column Head of both table, and make sure that the two are equal.
IN powerquery select the most recent table, and then "Apend New Queries"
