Learn how to unpivot static tables in Excel 2016 – Office Blogs

With the new Get & Transform capabilities in Excel 2016, you can now import, transform and combine data from different sources—thanks to the integrated Power Query technology in Excel. Today we are going to focus on one of the most useful capabilities that Get & Transform offers—the ability to use Unpivot to transform ANY table in your workbook to make it ready for powerful analysis using PivotTables and PivotCharts.

Πηγή: Learn how to unpivot static tables in Excel 2016 – Office Blogs