related comments from several lines in one cell

[Robo0502]

Hi guys,

need your help. It would be best if I show you example what I want to achieve.

tblComment:

PO Material Comment
123 Keyboard Not available
123 Keyboard Available from 23.2.
245 Mouse quality issue
245 Mouse Available


Result query should be:
PO Material Comment
123 Keybord Not avaible, Available from 23.2.
245 Mouse quality issue, Available

Basically I want to put related comments to one line divided by ",".

Could you pls help me?

Thank you

 

[pbaldy]

How about:

http://allenbrowne.com/func-concat.html

 

[Robo0502]

thanks pbaldy. that s perfect

 

[pbaldy]

Happy to help!