Pivot Data Field Blanks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Thanks for the quick reply. I would have liked a different answer but that is
reality.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parent of item in Pivot table 1
Listbox 3
Various data in a row for dulicate fields in column 3
Pivot table filter list - listing irrelevant subcategorys 1
Calculated Field in Pivot Table 1
Combo Box from SQL 2
Pivot Table - problem with repeated fields 5
row comparison 5

Back
Top