Row labels in pivot table (Excel 2007)

Caporegime
Joined
13 May 2003
Posts
34,559
Location
Warwickshire
Hello all

wefqsdf.jpg


In the above picture, how do I get the pivot table to fill the five digit number down into the blank cells, so I can analyse elsewhere, copy / paste, concatenate etc.? For example, '32001' in the selected cell needs to be filled down to match up with PKG, SPR, and SRV.

Many thanks :).
 
Back
Top Bottom