Common Tasks

Recent Posts

Community

Email Notifications

Personal Links

Archives

Security Protection - Harry Waldron (CS)

Security Best Practices, Breaking News, & Updates

Excel - Step by Step instructions on How to Pivot a Table

Computer I work with Excel spreadsheets often and recently captured the process for pivoting tables.  In the past I did it the "hard way" as formulas and even table matching techniques were used.  The Pivot function is much simplier than using formulas or macros, and works like magic in comparison.  The example shared is a simple one to illustrate to use the Pivot function.  With further experimentation, you can easily build upon this example.  When there is a lot of detailed information that must be summarized by keys, this will always be my first approach in the future. 

Who says you can't teach old dogs new tricks Wink  

Excel - Step by Step instructions on How to Pivot a Table
http://www.excelforum.com/showthread.php?p=1787972#post1787972

Please Download the attached Word Document with Step-by-Step Instructions ... "How to Pivot a Table.doc"