thats exactly wt i did later ;)....thnx 4 ur help paul......

"Paul Mugleston" wrote:

A bit of a different way to do it is to again use a pivot table but throw the
second column of the table into the "Column Labels" area and also put it into
the values box as a count. You then have a matrix with only single
occurences of the ID. with a one in the columns for where there is a value
recorded.

You can then replace (by column) the 1 with teh vlue of that column and then
put a concatenate statement at the end of each row.

If you need an example I can e-mail you something.
--
Paul Mugleston
Data Officer - UK