Summary  
The chapter covers techniques for combining multiple tables by appending (stacking rows with the same schema) and merging (joining tables on common columns), and explains the difference between vertical and horizontal data extensions.  

General domain of usage  
Data analysis

Handling multiple data sources is an essential skill for effective data analysis. You can use the **"Merge Queries"** feature to join tables based on a common column, similar to **SQL joins**, allowing you to create relationships between different datasets. For combining tables with similar structures, the **"Append Queries"** feature lets you stack them together, merging rows from different sources into one comprehensive table.

Below are the additional datasets you will use:

What feature in Power Query allows you to join tables based on a common column?

Gain a solid understanding of data visualization and storytelling with Power BI. Dive straight into the industry’s leading BI tool with a course designed for immediate application. You’ll move quickly from raw data to actionable insights by mastering the essential pipeline used by data professionals.

Handling Multiple Data Sources