Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    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.

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi Anonymous ,

 

You can create a new table like below:-

Table 3 = Union(table1,table2)

 

Thanks,

Samarth