Using the Power Query Add-In - Microsoft Business Intelligence Tools for Excel Analysts - page 149

Figure 7-29: Click the Custom column header to expand the table arrays.

With each table array expanded, Power Query shows the columns pulled from each Excel file
and adds the detailed records to the data preview. Figure 7-30 shows the data preview for
the final combined table.

15. Click the Apply & Close button to output the combined table.

Figure 7-30: The final combined view.

Don't lose track of the fact that this relatively complex task was facilitated by a custom
function. For all the steps required to accomplish this task, very little effort was actually
expended on writing the code for the function. Power Query wrote the code for the core
functionality, and you simply wrapped that code into a function.

Note