View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 380
Default Pivot Table Layout

Sure. There are a number of ways, but the simplest IMO is to grab a field in
the page fields, row fields or column fields, and drag it into one of the
other areas of the PT.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"SJT" wrote in message
...
I have created a pivot table and wish to change the layout of rows and

data
w/o recreating the table. Can I use the Pivot Table toolbar or another

means
to accomplish this? If so, how is this done? Thank you in advance for

your
assistance.