Connecting from a table or range
In Excel, the Get & transform tool is based on queries. With regard to a database, queries are used to retrieve data from a database. The reason why queries are so powerful is because we might only need a little bit of information from a huge dataset and the query will only give us the information that is required. The following screenshot shows a range of products that have been typed into an Excel worksheet. You will notice that, in column B, there are a number of cells that contain null values that we will have to fill in:
One of the ways in which we can do this is with the Get & Transform tool, which can be found in the Data ribbon. For us to use this in our query, we will have to convert this into a table. We can either select the range and use the Ctrl + T shortcut keys, or we can click Table in the Insert ribbon. We do not need to convert this into a table as Get &...