Forum Discussion
Problem changing rows to columns in a pivot table
I am a long time user of excel but new to pivot tables. I cannot get a pivot table to transpose the data from rows to columns. I have included an excel file with the source data and the pivot table...
If I understand you correctly you wish to transpose the entire pivottable, correct?
This is easy enough, just drag all fields from the "Rows" box to the Columns box and after that drag the "Sigma Values" "field" from the columns box to the rows box.
This is easy enough, just drag all fields from the "Rows" box to the Columns box and after that drag the "Sigma Values" "field" from the columns box to the rows box.