Found the following Crosstab SP that is exactly what I've been looking for: http://www.simple-talk.com/sql/t-sql-programming/creating-cross-tab-queries-and-pivot-tables-in-sql/

Trying to plug in my requirements and getting errors. Is there a way to step through a SP and identify the line causing the problem?

Yes, but you'll need to use visual studio, as you can't do it in Query analyser or SSMS