Transpose a Table in SSRS

        Some times we require to Transpose the table to see the data with more readability. Lets say we have an output as below :



         And we wish to see the data as below :




To achieve it, we need the following steps to do.

1) From the Tools Drag a Table.

2) Delete the Row group with related row :

3)  Delete Additional Columns.

4) Add a Column Group (checked with "Show Detail data").

5)  Insert the required number of rows(In our case its 3).

6) Bind Dataset Field Values to the Cells.

7) Add the Row Header in previous column.

8) Run the report and you will get the below output.







Reference: Govind Badkur(http://sqlserver20.blogspot.com)