How to use Append and Merge Query
How to use Append and Merge function in Power Query.
Append : Append queries allow you to combine data from multiple tables or queries by stacking them vertically.
Merge : Merge queries are used when you have two tables that share a common column.