May 05, · Hi friends, i need to convert Rows into columns in query for SSRS report. below is my exisitng query Results sets. Year Month Count 1 1 1 · Hi friends, i need to convert Rows into columns in query for SSRS report. This is what SSRS matrix (crosstab) report does automatically. Just run Report Wizard and select Matrix. Jan 04, · The XML option to transposing rows into columns is basically an optimal version of the PIVOT in that it addresses the dynamic column limitation. The XML version of the script addresses this limitation by using a combination of XML Path, dynamic T-SQL and some built-in T-SQL functions such as STUFF and QUOTENAME. Jun 01, · Converting Rows to Columns – PIVOT. SQL Server has a PIVOT relational operator to turn the unique values of a specified column from multiple rows into multiple column values in the output (cross-tab), effectively rotating a table. It also allows performing aggregations, wherever required, for column values that are expected in the final output.