Pivot Table Orientation

[Jarvonimbus]

I have a pivot table which has 7 data fields, 1 row field and no column fields

Now Excel puts the seven datafields as rows in the piot table

e.g.
Dealer Data
Wilmslow Opportunities 10
Contacted 20
Missed etc etc 10

I would like to have the datafields as columns

i.e.

Dealer Opportunities Contacted Missed etc etc
Wilmslow 10 20 10

Please can anyone advise if this can be done and how I should do it? Thanks in anticipation

 

[GlennUK]

Click and pull your data, and the pivottable shape will change.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[SkipVought]

"Click and pull your data button in the Pivot Table to the right , and the pivottable shape will change. "
_{my emphasis}

Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}

 

[Jarvonimbus]

Yep - job done

Much appreciated