Not within the actual pivot itself, but possible on a pasted special as
values copy
of it

Try Debra Dalgleish's page for ways to fill in the col blanks:
http://www.contextures.com/xlDataEntry02.html
Excel -- Data Entry -- Fill Blank Cells

Fill Blank Cells
Fill Blank Cells Programmatically
(Sub FillColBlanks() by Dave Peterson)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Nitesh Mathur" wrote:
I'm Using MS Excel 2003 ,presentally I'm facing a problem while copy a single
cell into multiple cells. General copy or drag system is working but if I
have a sheet in which "column A" have Employee name and "column B" have "
Projects name". When I'm creating PIVOT table then its shows only one emp.
name to assign one projects . And I'm making these cells copy(manually) &
then pasted in front of related projects;then after its shows exact number of
project count related to epm. name and this is a big exercise to do for 300
Employees.

Any method which can resolve my problem and save my time to do this exercise.
--
------------------------------
Thanks
Nitesh Mathur
------------------------------