Forum Discussion
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?
Thanks a billion
3 Replies
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.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!
