Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
You may take a look at the following posts.
You may take a look at the following posts.
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.
Help when you know. Ask when you don't!
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |