Pivot Data Field Blanks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 22 Nov 2006 18:42 GMT

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?

Reply to this Message

Dave Peterson - 22 Nov 2006 19:42 GMT

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

> 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:
[quoted text clipped - 10 lines]
>
> Any ideas?

Signature

Dave Peterson

Reply to this Message

Dave - 22 Nov 2006 20:00 GMT

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

> You can't do this and and keep it a pivottable.
>
[quoted text clipped - 19 lines]
> >
> > Any ideas?

Reply to this Message

Rate this thread: