Caporegime
- Joined
- 13 May 2003
- Posts
- 34,559
- Location
- Warwickshire
Hello all
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
.

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
