Split Column

Power Query from Scratch, Part 3: The transforms that actually matter

Unpivot, split column and group by all look foolproof, right up until the source file adds a column or a name gets typed slightly differently than expected.

16 July 2026