Changing the Layout of a Pivot Table

[prana1]

Good day!

How does one change the layout of a pivot table, so the results appear from
a format like this:

AvgA 7
AvgB 5
AvgC 8

to this:

Avg A AvgB AvgC
7 5 8

thanks very much!!

 

[Dave Peterson]

You can drag that grey looking Data button to the right.
Debra Dalgleish shows how:
http://contextures.com/xlPivot02.html#Multiple
and a video!
http://contextures.com/xlVideo001.html

 

[prana1]

Thank you!

You can drag that grey looking Data button to the right.
Debra Dalgleish shows how:
http://contextures.com/xlPivot02.html#Multiple
and a video!
http://contextures.com/xlVideo001.html

 

[Earl Kiosterud]

Prana1,

Now you know why they call it a "Pivot" table. Really.

 

[Dora Smith]

Well, them tables aren't clear cut to me.

 

[Earl Kiosterud]

Dora,

The pivot table's job is to look down a column, and group all the like things it finds, and
put one of each in the pivot table, either down the left or across the top. Then it gives a
total from another column of all the cells in each group, one for each group it found.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

Well, them tables aren't clear cut to me.