Neat stuff on Microsoft Excel, PowerPoint and maybe some random stuff
Pages
▼
Tuesday, July 16, 2019
Create a Reverse Pivot Table
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)
Some also call this an unpivot.
Reverse Pivot #2 video at https://youtu.be/sb81XE_jPd
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.