Excel Challenge - Pivoting poorly structured data

This is from an ExcelBI challenge.  I thought it may be worth while posting my solution here as a demonstration of modern Excel methods. Challenge Like many of such challenges, the natural solu...