In this example, we will retrieve smartphone data from the Web and perform some transformations on it, such as combining, unpivoting, splitting, and adding extra columns by performing the following steps. We will also append data from two different sources:
Open a new blank Excel spreadsheet and go to the POWER QUERY tab.
Tip
If you cannot find the POWER QUERY tab, download and install the Power Query add-in for Excel 2013 from http://www.microsoft.com/en-nz/download/details.aspx?id=39379.
In the POWER QUERY tab, click on the first icon from the left, named Online Search, as shown in the following screenshot. This option is a part of getting data from external sources. Also, with Online Search, you can extract data from online sources based on the result of a web search.
You will be redirected to a new tab named SEARCH, and in the right-hand pane, you will see a search pane. In the search box, type
smartphones 2013and press Enter. You will...