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.