Combining tables with the same columns

[ratgdillon]

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

[lbendlin · Accepted solution]

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]

@lbendlinHow would I do that?

[lbendlin]

use the Folder Source in Power Query and let it guide you through the steps.