Hi,

I've produced a pivot table to count the number of patients waiting in
various groupings. As excel nicely does, it's supressed repeated values when
there are more than one sub-categories within a main category...

e.g.

Sub heading Weeks Wait No. of Patients
Colonoscopy 0 25
1 20
2 15
3 6

Is there a way I can tell the pivot table to show "colonoscopy" on every row
rather than supress the repeated value? I can't seem to find an obvious way
of doing it.

Any help would be great.

Cheers,

David

Nothing simple. You have to copy the values out of the pivot table and
manipulet them in a regular sheet. You could do it with code and the code is
not too wild and crazy (not exactly simple but very doable).
--
HTH...

Jim Thomlinson


"DavidHawes" wrote:

Hi,

I've produced a pivot table to count the number of patients waiting in
various groupings. As excel nicely does, it's supressed repeated values when
there are more than one sub-categories within a main category...

e.g.

Sub heading Weeks Wait No. of Patients
Colonoscopy 0 25
1 20
2 15
3 6

Is there a way I can tell the pivot table to show "colonoscopy" on every row
rather than supress the repeated value? I can't seem to find an obvious way
of doing it.

Any help would be great.

Cheers,

David

Many thanks - i was hoping there was a way of doing it in the pivot table
itself as I was hoping to save the manual copying and pasting etc but I
suppose it's a limitation of pivot tabels.

Thanks again.

"Jim Thomlinson" wrote:

Nothing simple. You have to copy the values out of the pivot table and
manipulet them in a regular sheet. You could do it with code and the code is
not too wild and crazy (not exactly simple but very doable).
--
HTH...

Jim Thomlinson


"DavidHawes" wrote:

Hi,

I've produced a pivot table to count the number of patients waiting in
various groupings. As excel nicely does, it's supressed repeated values when
there are more than one sub-categories within a main category...

e.g.

Sub heading Weeks Wait No. of Patients
Colonoscopy 0 25
1 20
2 15
3 6

Is there a way I can tell the pivot table to show "colonoscopy" on every row
rather than supress the repeated value? I can't seem to find an obvious way
of doing it.

Any help would be great.

Cheers,

David

If you were needing it, the way to fill in the blank cells quickly would be
as follows:

copy the pivot tabel columns
Past Special Values in empty columns.
in cell directly below, say Colonoscopy, (let's assume this value is now in
D4)
type =D4 in cell D5
copy D5
select columns you would like to do fill-in for
Edit - Go to - Special - Blanks
paste

Then, highlight the columns again and paste special- values.

"DavidHawes" wrote:

Many thanks - i was hoping there was a way of doing it in the pivot table
itself as I was hoping to save the manual copying and pasting etc but I
suppose it's a limitation of pivot tabels.

Thanks again.

"Jim Thomlinson" wrote:

Nothing simple. You have to copy the values out of the pivot table and
manipulet them in a regular sheet. You could do it with code and the code is
not too wild and crazy (not exactly simple but very doable).
--
HTH...

Jim Thomlinson


"DavidHawes" wrote:

Hi,

I've produced a pivot table to count the number of patients waiting in
various groupings. As excel nicely does, it's supressed repeated values when
there are more than one sub-categories within a main category...

e.g.

Sub heading Weeks Wait No. of Patients
Colonoscopy 0 25
1 20
2 15
3 6

Is there a way I can tell the pivot table to show "colonoscopy" on every row
rather than supress the repeated value? I can't seem to find an obvious way
of doing it.

Any help would be great.

Cheers,

David