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 result.

Thanks in advance..!!

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.

8 Replies

  • 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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks Samarth_18 

      But can u please tell me , how can we do it in Power Query?