Collect, Combine, and Transform Data Using Power Query in Excel and Power BI, First Edition

CHAPTER 5Preserving Context

For me context is the key—from that comes the understanding of everything.

—Kenneth Noland

IN THIS CHAPTER, YOU WILL

• Learn how to preserve context from file names and worksheets when you append queries

• Learn how to apply the Drill Down transformation on titles and dynamically preserve their content in tables

• Preserve titles as a pre-append phase by using Drill Down and a custom column to combine multiple tables from a folder

• Preserve titles as a post-append phase by using Drill Down, conditional columns, and the Fill Down transformation to combine multiple worksheets from a workbook

• Learn advanced techniques for preserving specific cells from a grid using index and proximity cues

In Chapters 3, “Combining Data from ...