display all row fields in pivot table

[Elle Tee]

I have a pivot table which groups my row fields and shows blank cells. I
want to show all field cells.

Basically, I have:

Sales Bob Client ABC Contract 1 Project 1
<blank> <blank> <blank> Project 2
<blank> <blank> Contract 2 Project 1
<blank> Client XYZ Contract 1 Project 1

I want to display as:
Sales Bob Client ABC Contract 1 Project 1
Sales Bob Client ABC Contract 1 Project 2
Sales Bob Client ABC Contract 2 Project 1
Sales Bob Client XYZ Contract 1 Project 1

Is this possible?

 

[Gary Brown]

Meant...
=if(len(a2)<>0,a2,f1
Sorry!
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown

The only way I know to do that is to create formulas outside the Pivot table
that fill in the info using formulas like [assuming the formulas start in
column F]...
=if(len(a2)=0,a2,f1

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown

I have a pivot table which groups my row fields and shows blank cells. I
want to show all field cells.

Basically, I have:

Sales Bob Client ABC Contract 1 Project 1
<blank> <blank> <blank> Project 2
<blank> <blank> Contract 2 Project 1
<blank> Client XYZ Contract 1 Project 1

I want to display as:
Sales Bob Client ABC Contract 1 Project 1
Sales Bob Client ABC Contract 1 Project 2
Sales Bob Client ABC Contract 2 Project 1
Sales Bob Client XYZ Contract 1 Project 1

Is this possible?