Merging Data


The Merge Queries tool in Power Query allows you to join two tables based on a shared column, combining related data from each table into a single dataset.

  • Most data software have some ability to join data sets together through the use of merge tools
  • ability to pick up and merge data sets together via a common field or fields allows us to tie critical information together in record format
  • Queries are a form of merging data
    • include the tables and the join type
  • merge tool will allow you to select the tables and establish the join types