Compile "Unpivot Table" with the Power Query. If you interested how to Unpivot with formulas or VBA then see here.