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.