Merging tables in one sheet

[Alirezam]

Hi experts,

I have attached an excel file. The data come in multiple tables within the same worksheet. However, I need to put them all in one table.

Any indication how to do it in excel or power bi?

Thanks a billion

https://1drv.ms/x/s!Al3r7IU8GY3yznb9XYKbvPaL0pUQ?e=53Z79J 

[v-chuncz-msft · Accepted solution]

@Alirezam 

You may take a look at the following posts.

• https://community.powerbi.com/t5/Desktop/Noob-needs-help-with-shaping-data/m-p/755902#M364227
• https://community.powerbi.com/t5/Desktop/Unpivot-multiple-columns-without-duplicates/m-p/662578#M318...

[kentyler]

If you load all three tables into Power BI

then open the query editor

then you can use the Append Queries action to append the table together into one table

You may need to first append one table to the other, and then append the third table to the combined table
I'm a personal Power BI Trainer 
I learn something every time I answer a question.

[Alirezam]

Thanks for taking time. However, it was just an example. Instead of 3 tables I have 60! I cannot copy them manually. Besides, in Power Bi you can append te tables when they coem from different files. Here we just have 1 file!