You can pivot a Crosstab in two ways:

  • Pivot the entire Crosstab by clicking the  Pivot icon . The row and column groups switch places. 

  • Pivot a single group: 

    • To pivot a single row group, right-click it and select  Switch To Column Group

    • To pivot a single column group, right-click it and select  Switch To Row Group 

Pivoting removes any custom sorting applied to headings in Crosstab. It does not affect column or row sorts.