for ex; lets say i have 5 columns that contain only texts and no numbers.

Customers Residential City Model Purchased Repeat Customer
XXXXX RRR A0001 Yes
YYYY PPP A0002 No
ZZZZZ KKK A0003 No
AAAA RRR A0001 Yes
BBBB PPP A0003 Yes

This extends to 10000 rows. No I wish to make a table such that I know that
in a particular city, a particular model was purchased by these customers.
Should ideally look like:

City/Model A0001 A0002 A0003
RRR XXXX,AAAA
PPP YYYY BBBB
KKK ZZZZ

I hope you get it or if an alternate way is possible pls share., thx



"Roger Govier" wrote:

Hi

I'm not sure what you are meaning. Can you give an example?

--
Regards
Roger Govier



"Malik" wrote in message
...
Thanks Roger..but is there a way in xl where we cn do this?
I mean text to text comparison.

"Roger Govier" wrote:

Hi

No you can't.
You could add the filed to the Row area, and again to the Data area, and
the
PT will show a count of the occurrence of the text items.

--
Regards
Roger Govier



"Malik" wrote in message
...
Can I place "Text" in the "data items" of the Pivot table?