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. 

  • Facebook Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon
  • YouTube
Follow us to receive free templates, tips & tricks, turorials, and more

Home - Site mapTerms - Data Privacy - Version history - About us - Affiliates

©2015-21 Power-user SAS - Paris (FRANCE) - Registration n°813 623 733