How does one create a Matrix Report to convert sql columns as rows?
The functionality you are looking for goes under the name UNPIVOT.  I'd suggest you have a good search on that subject and post a new question if you have further, specific question.