Forum Discussion
ratgdillon
5 years agoFrequent Visitor
Combining tables with the same columns
Hi all, I have a growing list of monthly tables with the same format that I would like to combine into one long summary table. What is the most efficient way to combine all rows of my tables into...
- 5 years ago
There's no need to update anything manually. You create a Power Query source that points to a folder rather than a file. Then you can collect all the files in that folder and combine them into a single query. Newly added files will automatically be included on the next refresh.
ratgdillon
5 years agoFrequent Visitor
lbendlinHow would I do that?
lbendlin
Super User
5 years agouse the Folder Source in Power Query and let it guide you through the steps.