Aug 10, 2026, 10:30:00 AM
A powerful, yet little-known feature
Working with multiple values in a cell
Ever found yourself faced with this kind of data in Excel? Multiple values are being stored in a single cell. This is notoriously difficult to handle in Excel.
That is, unless you know the Split by Row feature in Power Query.
In this brief walk through video I show you the few simple clicks to transform this data into a useable structure.
Once it has transformed the data I then load it directly into a Pivot Table and spin up a quick Pivot Chart to visualise the output.
