Back in the Power Query Editor, note that an additional step has been added to this query called Merged Queries, as shown in the following screenshot. In addition, an additional column has been added called Tasks. This column's row values say Table in yellow text. We wish to expand this table. To do this, perform the following actions:

1. Click the diverging arrows icon on the far right of the column header for the Tasks column. This icon is used to expand the columns that contain table information.
2. Uncheck the checkbox next to TaskID and uncheck the checkbox for Use original column name as prefix, as shown in the following screenshot:

3. Click the OK button.
4. Note that the Tasks column changes to Category and that our task category values are listed in each row. Also, a step has been added to our query: Expanded Tasks.