Reorient Pivot Table Data

[JB]

Hello,
Is it possible to reorient pivot table Data from rows to columns? An
example is as follows:

Now (data is correct)

TYPE SUBTYPE DATA
A 1 Permits 5
Value $1,500,258
Lots 25
A 2 Permits 3
Value $1,253,000
Lots 12

==================================================================
To This:

TYPE SUBTYPE Permits Value Lots
A 1 5 $1,500,258 25
A 2 3 $1,253,000 12

Thanks,
JBESr

 

[Debra Dalgleish]

To arrange the data fields horizontally, drag the Data button onto the
cell that contains the word Total. There's a screen shot here:

http://www.contextures.com/xlPivot02.html#Multiple

 

[Dave Peterson]

Try dragging that DATA looking grey button to its immediate right (drop it on
Totals).

(And if you have subtotals you don't want, just double click on the header and
change it to None.)