UNPIVOT TABLE

The UnPivot Table feature is a great tool of Power-user for Excel. It lets you "flatten" a crosstab table, turning it into a database in just a few seconds.

​

This can help you in various situations to get your data in a format that can be integrated within a larger database. Also, if you are experienced with Excel, you probably know that it's always more efficient to have your data displayed in a database format, with each column corresponding to a different nature of data.

​

This allows you to use PivotTables, PivotCharts, Slicers, Timelines, etc. to make your data dynamic to present.