Forum Discussion

ratgdillon's avatar
ratgdillon
Frequent Visitor
5 years ago
Solved

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...
  • lbendlin's avatar
    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.