Merging and appending tools
In this section, we will understand how to combine, merge, and extract data from sources within Power Query. These are extremely powerful and useful tools that can be used to transform data.
Merging columns using combine
We can merge data sources or data tables whose structures are totally different from each other. The only thing we require is a relationship between the sources. This is normally a common field that relates one field in the first data source to another field in the second data source. This concept is exactly the same as working with primary keys, relationships, and joins in Access 2019.
If we have a list of student data in one table and data related to fees that have been paid per student in another table, we can merge them to flatten the data into one table. The Merge tool offers you the ability to select a common field and create a relationship between the two tables so that data can be combined into a single flattened data table...