Forum Discussion

Alirezam's avatar
Alirezam
Icon for Helper V rankHelper V
6 years ago
Solved

Merging tables in one sheet

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...
Need Help
kentyler's avatar
kentyler
Icon for Solution Sage rankSolution Sage
6 years ago

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's avatar
    Alirezam
    Icon for Helper V rankHelper V
    6 years ago

    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!