Forum Discussion
Merge Two Tables
Hi Community..!! I want to merge two columns in such away that table2 data should come below to the table1 data Table1 Table2 In New merged column ,I should get only 2 columns as a re...
Anonymous , For achieving this in power query you have to first rename column name of your table 2 and make it same as table 1 then follow what David-Ganor has suggested. You will get 2 column only.
Hi David-Ganor
If I use append then its creating four columns , that I dont want.
Result should comes in 2 coulmns only.
U can read my first question carefully for better understanding.
Anonymous , For achieving this in power query you have to first rename column name of your table 2 and make it same as table 1 then follow what David-Ganor has suggested. You will get 2 column only.
Thank You Samarth_18