powerquery

Philip Trick
Members Public

QuickTip: Consolidate Excel Data

Consolidate data from multiple tables within Excel into one table using PowerQuery, a basic function, and a parameters table in under 7 minutes.

Philip Trick
Members Public

The Promise Of PowerQuery Custom Data Types

PowerQuery custom data types offer promise of bold and powerful new features in the future; however, their current implementation is currently limited to simple, non-hierarchical data.

Philip Trick
Members Public

Quick Tip: Find The Missing (Data) Links

This QuickTip offers a quick use-case for PowerQuery's Merge command to connect data together in order to locate potential missing pieces.