gather data in one field

[le_sayan]

Hello,

I have a table A with data like this :

Key Comment
A bla
A blabla
B bli


C blo
C bloblo
C blobloblo

I would like to gather all the comments for each key in a field like this:

Key New_field
A bla blabla
B bli
C blo bloblo blobloblo

How should I proceed ?

Thank you in advance.

[June7]

That requires VBA procedure. Review: http://allenbrowne.com/func-concat.html