Combine Data with Different Columns on Multiple Sheets into a Single Sheet

[nmhung49]

I have 2 sheets with data

Sheet 1

Product Group 1     Customer     Produc Group 2    Amount

A                               Hiti              Arg                       10

B                               Van             Bra                         20

Sheet 2

Product Group 2    Produc Group 1    Customer    Amount

Vie                               C                      Chien                 30

Tha                              D                       Tu                      40

Now I want combine 2 sheet to 1 sheet in Power query or Power Bi, How?

Product Group 1     Product Group 2     Customer    Amount

A                               Arg                       Hiti                       10

B                               Bra                        Van                      20

C                               Vie                        Chien                   30

D                               Tha                       Tu                        40

Thanks for your help!!

[v-danhe-msft]

Hi @nmhung49 ,

Based on my test, you could achieve this result by using append function, but you need to make sure each of column name is same with the other table:

Table 1

Table 2

Append the two tables:

You could also download the pbix file to have a view.

Regards,

Daniel He

[nmhung49]

Thanks @v-danhe-msft 

If I add a table 3 into data, it does not automatically update to the append1 table.

How way have we to automatically update it?

[v-danhe-msft]

Hi @nmhung49 ,

If you want to append files automaticlly, you need to get data form files, you could refer to below link to have a view:

https://community.powerbi.com/t5/Desktop/Get-data-from-folder-and-append/td-p/526274

Regards,
Daniel He