This tutorial covers how to convert crosstab to list, crosstab to flat file in Excel, pivot table to data table, also known as unpivot data. Other than crosstab to table you will also learn some other techniques of data transformation using Power Query in Microsoft Excel.

Applicable for Windows Excel 2010, 2013, 2016.

Download Power Query addon here
https://www.microsoft.com/en-us/download/details.aspx?id=39379