need some help with pivot
 

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
1 fax 212
1 ofice 213
1 web ww.a.com
2 email
2 fax 215


i want the result to be:

client id email fax ofice web
1 212 213 ww.a.com
2 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

need some help with pivot
 

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