You can use features in Excel to unpivot your dataset:
- PowerQuery (Excel for Office 365, Excel 2016, Excel 2013, Excel 2010).
- Get & Transform (Excel 2016).
Get & Transform in Excel 2016 provides additional context to the new Get & Transform features in Excel.
You can unpivot your dataset manually, by moving distinct columns into rows and renaming columns, as well.