Searching and Combining Data with Power Query

This chapter provides an introduction for searching and combing data using Power Query after showing how to install the Power Query add‐in so that it is available inside Excel. The chapter details how Power Query can be used to perform certain operations, for example combining two disparate datasets into one using Excel alone, that were difficult or impossible prior to the addition of Power Query within Excel. Power Query has so far proven to be an ally in importing and combing data, but what about adding information that does not exist, such as aggregated data. It provides two very intuitive approaches to aggregating data: aggregating data using the Group By Option and the Transform Ribbon. Although one can accomplish most tasks in Power Query through its graphical user interface, it also includes a very powerful programming language known as M.