show detail in pivot table

R

robbie

Hi

my pivot is set up like this

code product qty
0204 a 30
b 35
0205 a 30
b 35

I would like it to read
code product qty
0204 a 30
0204 b 35
0205 a 30
0205 b 35

help please
 
O

olasa

You could use this formula in column D:
=IF(ISBLANK(A5),A4,A5)

You can't do what you want to do, in the Pivottable.

Ola
 
R

robbie

thank you for clearing that up, I have managed to force a duplication through
using an autonumber for each entry,

cheers
Robbie
 
G

goldyjk

if i copy and paste values for my pivot table is there an easy way to fill in
the blanks - my list is 10000 rows and it would take hours to fill in manually
 
O

olasa

I think Debra's homepages explains it well.

Anyhow, do this:
1. Copy the Pivottable and Past it as Values.
2. Put the cursor in the first blank cell, and write ='the cell above'.
I.e. if you put the cursor in A2, write =A1.
3. Copy the formula you just wrote
4. Then select the area with the blanks. Press Ctrl+G, click Special...
and select Blanks
5. Select from the menu: Edit>Paste Special... Paste: Values

Done!

Hope it helped
Ola Sandström
 
Top