I work with Excel spreadsheets often and recently captured the process for pivoting tables. I had used formulas and even table matching techniques and this process is much simplier and works like magic.
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
P.S. Please select the attachment link "How to Pivot a Table" at the bottom of this post for a Word document with screen excerpts showing the step-by-step process.