Excel Training 101
Neat stuff on Microsoft Excel, PowerPoint and maybe some random stuff
Pages
Home
Book Resources
PM Resources
Training
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment