Transposing rows and columns

  1. Activate the pivot table.
  2. From the menus choose:

    Pivot > Transpose Rows and Columns

This has the same effect as dragging all of the row elements into the column dimension and dragging all of the column elements into the row dimension.