Introducing Power Query

Each time you use Power Query, you will work through a series of at least three, and sometimes as many as five, phases:

• Connecting: Power Query enables you to connect to a variety of data sources, including worksheet ranges, workbooks, text files, PDF files, and databases.

Nuance

Any worksheet ranges that you connect to within an Excel workbook will automatically be converted into Tables.

• Transforming: The Power Query Editor enables you to shape your data, much like a potter shapes a lump of clay, but in this case, you can opt to remove unnecessary rows and columns, add columns, separate data from a single column into two or more columns, and much more.
• Combining: The optional combining phase enables you to stack different datasets together, such as combining individual worksheets from a workbook into a single list or merging data, which is akin to using lookup formulas in Excel to match related data from a second list into list...