need some help with pivot

[adam]

hi,
Im trying to do a pivot table where the value is the actually text and not a
count or something.
example:

client id type data
1 email [email protected]
1 fax 212
1 ofice 213
1 web ww.a.com
2 email [email protected]
2 fax 215


i want the result to be:

client id email fax ofice web
1 [email protected] 212 213 ww.a.com
2 [email protected] 215

and not (this is what i get)


client id email fax ofice web
1 1 1 1 1
2 1 1

can anyone please help me out on this?

Thanks

 

[Herbert Seidenberg]

This translates
your Pivot Table to a text Table:
(Excel 2003 with Macros)
http://www.freefilehosting.net/download/3d8ma