posted 7/22/2011 by SQLKohai - Views: [1290]
http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/how-to-unpivot-and-pivot
I'd been having trouble wrapping my brain around how to do it, and also, how to unpivot as well. Great article, and I only used the first part of it to get the answer I needed! :)