Power Query is a built-in feature in Excel 2016 - Excel 365, but it can also be downloaded in Excel 2010 and Excel 2013 and used as an add-in.In simple terms, Power Query (also known as Get & Transform is a tool to combine, clean and transform data from multiple sources into the format you need such as a table, pivot table or pivot chart.Īmong other things, Power Query can join 2 tables into 1 or combine data from multiple tables by matching data in columns, which is the focus of this tutorial.įor the results to meet your expectations, please keep in mind the following things:
Excel power query examples how to#
How to join tables with Excel Power Query Merge Tables Wizard - quick way to combine tables in Excel.The good news for all Excel users - Power Query or Merge Tables Wizard can be your time-saver. A macro, you believe, could do the job in no time, if only you knew how.
If you are an experienced Excel pro, then you can possibly rely on VLOOKUP and INDEX MATCH formulas. If you decide to do it manually, you may spend hours only to find out that you've messed up important information. In this tutorial, we will look at how you can join tables in Excel based on one or more common columns by using Power Query and Merge Tables Wizard.Ĭombining data from multiple tables is one of the most daunting tasks in Excel.