concatenate all comments of same users

[aarona]

Hi All,

Not sure if this should be posted here.

Just wondering if this is possible.

I want to concatenate all of the comments of the same users.

Take note that the length of the data is not fixed.

Sample output workbook is attached.

Again, thanks for your help!

[KOKOSEK]

Hi

try into B1

={TEXTJOIN(" ",1,IF(Data!A2:A20=Output!A2,Data!I2:I20,""))} it is array formula so CSE needed.

[Bo_Ry]

If you don't have Textjoin

B2
=SUBSTITUTE(LEFT(C2&D2&E2&F2&G2&H2,LEN(C2&D2&E2&F2&G2&H2)-1),",",CHAR(10))

C2 drag to the right

=IFERROR(INDEX(Data!$I:$I,AGGREGATE(15,6,ROW(Data!$A$2:$A$20)/(Data!$A$2:$A$20=Output!$A2),COLUMNS($C2:C2)))&",","")

[aarona]

Thanks KOKOSEK, working!