Transposing a Pivot Table Transposing a Pivot Table You can transpose a pivot table; that is, switch its rows and columns. To do so, click the Transpose button .