Query Filtering: Filter out irrelevant data for more efficient processing. Table Combining: Use the ‘Append Queries’ feature to merge tables into a unified dataset.

In the Queries list to the right, right-click the January query—at this point, Power Query calls them queries. In the resulting list, click Append (Figure E). Figure E Choose Append.

It took three entries for Power Query to catch up with the pattern. In this basic example, you don’t gain much; however, if you have dozens or even thousands of records, this feature comes in handy.