Forum Discussion

duycao's avatar
duycao
Frequent Visitor
6 years ago
Solved

Merge multiple table into one

Hi there,   I'm looking for a solution to merge multiple tables into a single table. In particular, I have 2 tables (or maybe more) each stores different kind of data so, at the end of the day, I w...
Need Help
Tutorial Requests
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi duycao ,

     

    We can merge them into a new table in Power Query Editor:

     

    1. Here is our sample data

    2. Merge two tables, use ctrl to click on multi matched columns

     

    3. expand the column in table 2

     

     

     


    Best regards,

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi there - 

 

I may be able to help out here. Could you please provide a sample pbix file with the original two tables with some sample data in it? That should help me to give a starting point.

 

Regards

E