Part V: Understanding Power Pivot and Power Query
FIGURE 40.15
Expand the NewColumn field, and choose the merged fields you want output.
- At this point, you can apply more transformations if needed. When you’re
happy with the way things look, click the Close & Load command to output the
results to the workbook.
Figure 40.16 illustrates the final merged query.
FIGURE 40.16
The final table with merged questions and answers
When working in the Power Query Editor, you may see the word null wherever there are empty values. You don’t need
to take any special action to get rid of all of the instances of the word null. Excel automatically recognizes these as
empty values, and it won’t show them in the final worksheet.
If you find that you need to adjust or correct a merged query, right-click the query in the
Queries & Connections pane and select Edit. In the Power Query Editor, click the gear icon
