Create a Reverse Pivot Table #2 HD
Subscribe to Channel: http://goo.gl/wN3c3p View the Blog: http://myexcelcharts.blogspot.com How to create a database table from a summary table. Basically creating a reverse pivot table. This tip uses the Pivot Table Wizard (keyboard short cut ALT+D+P) and the transpose feature. This example show a more complicated scenario where there are nested column headings. Reverse Pivot #1 video at https://youtu.be/N3wWQjRWkJc P.S. Feel free to provide a comment or share it with a friend! ------------------------------------------------------------------------------------------------- WHERE TO GET THE TOOLS I USE (affiliate link): Camtasia: http://goo.gl/qdDBnP