Thanks very much for both reply. Your solution would be helpful for few
entries. However in my case, there are more than 30 cases. It will be time
consuming.

BTW, I notice that using the PIVOT Table wizard can do something like this
and can have some descriptive statistics. Please refer to the help of PIVOT
table in excel help.

"nijunge" wrote:


I'm not totally sure of the question but to combine more sels into one
is generally done by the function Concatenate

ex

=Concatenate(a1;" - ";b2;"and so on he goes")

was that the problem ?


--
nijunge
------------------------------------------------------------------------
nijunge's Profile: http://www.excelforum.com/member.php...o&userid=26404
View this thread: http://www.excelforum.com/showthread...hreadid=398933