Thread
:
Changing the Layout of a Pivot Table
View Single Post
#
6
Posted to microsoft.public.excel.misc
Earl Kiosterud
external usenet poster
Posts: 611
Changing the Layout of a Pivot Table
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
-----------------------------------------------------------------------
"Dora Smith" wrote in message
...
Well, them tables aren't clear cut to me.
--
Yours,
Dora Smith
Austin, TX
"Earl Kiosterud" wrote in message
...
Prana1,
Now you know why they call it a "Pivot" table. Really.
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"prana1" wrote in message
...
Thank you!
"Dave Peterson" wrote:
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 wrote:
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
Reply With Quote
Earl Kiosterud
View Public Profile
Find all posts by Earl Kiosterud