Excel - Step by Step instructions on How to Pivot a Table
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
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"