Pivot Data Field Blanks

[Dave]

I would like a Pivot table with data in all fields all rows even if the first
column is repeated. I now have the following result:

Company City Country
AAA Manchester UK
Manchester USA

What I want is:

Company City Country
AAA Manchester UK
AAA Manchester USA

Any ideas?

 

[Dave Peterson]

You can't do this and and keep it a pivottable.

You could convert it to values (select, edit|copy, edit|paste special|values)
(or do the same thing against a copy)

Then use some of the techniques at Debra Dalgleish's site to fill the empty
cells:
http://www.contextures.com/xlDataEntry02.html

 

[Dave]

Thanks for the quick reply. I would have liked a different answer but that is
reality.