software

Hello,

I have a Pivot Table which displays 3 fields. By defaults, Excel groups the
data and removes the repeating data. For example, I have the following:

CustId Account# Balance
1 A1 200
1 A2 300
2 A3 400

Excel displays this as,

CustId Account# Balance
1 A1 200
A2 300
2 A3 400

Note that it doesn't display CustId in the 2nd row. But I want it to display
it. How can I do this?

Thanks
Vasan

Try Debra Dalgleish's page for
some nice ideas on filling in the blank cells:
www.contextures.com/xlDataEntry02.html
Fill Blank Cells
Fill Blank Cells Programmatically
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Vasanquot; gt; wrote in message
...
gt; Hello,
gt;
gt; I have a Pivot Table which displays 3 fields. By defaults, Excel groups
the
gt; data and removes the repeating data. For example, I have the following:
gt;
gt; CustId Account# Balance
gt; 1 A1 200
gt; 1 A2 300
gt; 2 A3 400
gt;
gt; Excel displays this as,
gt;
gt; CustId Account# Balance
gt; 1 A1 200
gt; A2 300
gt; 2 A3 400
gt;
gt; Note that it doesn't display CustId in the 2nd row. But I want it to
display
gt; it. How can I do this?
gt;
gt; Thanks
gt; Vasan
But this won't work if it's still a pivottable.

The OP can either copy|paste special|values first, then do this.

Or copy to a new worksheet (as values). Then do it against that sheet.

Max wrote:
gt;
gt; Try Debra Dalgleish's page for
gt; some nice ideas on filling in the blank cells:
gt; www.contextures.com/xlDataEntry02.html
gt; Fill Blank Cells
gt; Fill Blank Cells Programmatically
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt; quot;Vasanquot; gt; wrote in message
gt; ...
gt; gt; Hello,
gt; gt;
gt; gt; I have a Pivot Table which displays 3 fields. By defaults, Excel groups
gt; the
gt; gt; data and removes the repeating data. For example, I have the following:
gt; gt;
gt; gt; CustId Account# Balance
gt; gt; 1 A1 200
gt; gt; 1 A2 300
gt; gt; 2 A3 400
gt; gt;
gt; gt; Excel displays this as,
gt; gt;
gt; gt; CustId Account# Balance
gt; gt; 1 A1 200
gt; gt; A2 300
gt; gt; 2 A3 400
gt; gt;
gt; gt; Note that it doesn't display CustId in the 2nd row. But I want it to
gt; display
gt; gt; it. How can I do this?
gt; gt;
gt; gt; Thanks
gt; gt; Vasan

--

Dave Peterson

quot;Dave Petersonquot; wrote
gt; But this won't work if it's still a pivottable.

Thanks. Yes, I missed that point in the OP.
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
..