How do I get PivotTable data results to show in columns instead ro

[GeorgeK@Novagard]

In Pivot Tables you have your data that you drag and drop as page, column and
row separators for your data. In the actual data field you can have sum,
count , average,... fields to choose from for what you want to see. This
information always shows results by row. I want to know if you can see the
results in columns. An example would be that I look at Count and average for
my given data. The count is in one row and the average is in the nixt row.
I would like the results to show the count in the first row and the average
to be in the same row , next column. Can this be done and How? I have tried
to use the PivotTable Table Options athat shows rows then columns or columns
then rows, but this does not change anything in my results no matter wich one
I choose.

 

[George Nicholson]

You need to Drag & Drop to make this change.

-Click on one of the grey labels for one of the fields in your Data Area.

-*Carefully* drag that label up and to the right just a *little* bit. (Pivot
the field label on itself *within* the Data Area). Very little movement is
required for this. Barely a twist of the wrist.

Very easy, but you might need a little bit of trial and error practice.

 

[GeorgeK@Novagard]

I am using Excel 2003. I tried to do what you said but the field either
stays where it is or jumps above the other field. I am doing this in a pivot
table with only two data fields, count and average.They will not show side by
side

 

[George Nicholson]

I'm using Excel 2003, and while it may require trial and error, it is
possible.

 

[GeorgeK@Novagard]

Any chance you could send me a file with the example? I tried slowing my
pointer down but still could not accomplish the task. You can send it to
(e-mail address removed) Thanks!