Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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!! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |