A
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 (e-mail address removed)
1 fax 212
1 ofice 213
1 web ww.a.com
2 email (e-mail address removed)
2 fax 215
i want the result to be:
client id email fax ofice web
1 (e-mail address removed) 212 213 ww.a.com
2 (e-mail address removed) 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
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 (e-mail address removed)
1 fax 212
1 ofice 213
1 web ww.a.com
2 email (e-mail address removed)
2 fax 215
i want the result to be:
client id email fax ofice web
1 (e-mail address removed) 212 213 ww.a.com
2 (e-mail address removed) 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