Whatever user requested to see the data pivoted into this cross-tab format should do it themselves within the reporting tool.
Create a Matrix (Report Builder and SSRS)
https://msdn.microsoft.com/en-us/library/dd207149.aspx
Office Excel 2010 Tutorial: Pivot Tables
http://www.addictivetips.com/windows-tips/office-excel-2010-tutorial-pivot-tables/
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho