I was posed a question a few months back on another site about being about to create a Pivot Table (Horizontal version of vertical data) and I saw the question again today. This will allow you to do that, just make changes to the query where the title is the replacement need. It will build a dynamic query (sorry there is an 8000 character limit) to do this without you having too. You can also specify a time frame. Any question let me know.
A short but interesting article, the author has figured out a way to create a PDF from a stored procedure without using a third party library.