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

Question

I have 2 sheets with dataSheet 1Product Group 1&nbsp; &nbsp; &nbsp;Customer&nbsp; &nbsp; &nbsp;Produc Group 2&nbsp; &nbsp; AmountA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Hiti&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Arg&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Van&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Bra&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20Sheet 2Product Group 2&nbsp; &nbsp; Produc Group 1&nbsp; &nbsp; Customer &nbsp; &nbsp;AmountVie&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Chien&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30Tha&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Tu&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40&nbsp;Now I want combine 2 sheet to 1 sheet in Power query or Power Bi, How?Product Group 1&nbsp; &nbsp; &nbsp;Product Group 2&nbsp; &nbsp; &nbsp;Customer&nbsp; &nbsp; AmountA&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Arg&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Hiti&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Bra&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Van&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Vie&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Chien&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Tha&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Tu&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 40&nbsp;Thanks for your help!!

v-danhe-msft · Answer

Hi&nbsp;nmhung49&nbsp;,
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.
&nbsp;
Regards,
Daniel He

nmhung49 · Answer

Thanks&nbsp;v-danhe-msft&nbsp;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 · Answer

Hi&nbsp;nmhung49&nbsp;,
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
&nbsp;
Regards,Daniel He

Forum Discussion

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

3 Replies

Related content

Power Query Combine Multiple Files From Folder

Tables combine

Combining Data from Different Semantic Models

Combine values from multiple rows

Combine multiple measures into one