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!!

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

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

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

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

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