Forum Discussion
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 one table? The easier it is for someone with minimal coding experience to update this formula every month, the better.
Thanks!
July Table:
| Date | Product | Sales |
| 7/4/19 | Pepsi | $299 |
| 7/13/19 | Coca-Cola | $283 |
| 7/23/19 | Pepsi | $238 |
August Table:
| Date | Product | Sales |
| 8/1/19 | Pepsi | $283 |
| 8/19/19 | Coca-Cola | $123 |
| 8/26/19 | Pepsi | $234 |
September Table:
| Date | Product | Sales |
| 9/9/19 | Coca-Cola | $345 |
| 9/12/19 | Coca-Cola | $394 |
| 9/20/19 | Pepsi | $832 |
Summary Table:
| Date | Product | Sales |
| 7/4/19 | Pepsi | $299 |
| 7/13/19 | Coca-Cola | $283 |
| 7/23/19 | Pepsi | $238 |
| 8/1/19 | Pepsi | $283 |
| 8/19/19 | Coca-Cola | $123 |
| 8/26/19 | Pepsi | $234 |
| 9/9/19 | Coca-Cola | $345 |
| 9/12/19 | Coca-Cola | $394 |
| 9/20/19 | Pepsi | $832 |
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.
3 Replies
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.
lbendlinHow would I do that?
use the Folder Source in Power Query and let it guide you through the steps.
