Appending queries

Each year of sales data for Northwind traders is stored in a different Excel file. Your manager has asked you to combine all the sales data to be able to analyze total sales for the years 1996-1998.

More information about appending queries can be found in this MSFT Learn article.

You will make use of the append query feature in Power Query to accomplish this.