The course "Analyzing and Visualizing Data with Power BI" hosted by includes a section that demonstrates transforming "less structured data", but does not include the spreadsheet as part of the course files. Download this .xslx file to work through the examples on your own as they go through the data transformation steps.

This is currently video "Transforming Less Structured Data" in Section 1.

Sam Lester (MSFT)