Vlookup different values into one value

[Bozovicdj]

Good day all,

First post, this one is giving me a lot of trouble, and is very important for me to figure out a solution,

Basically I need to put all the values from column 2 (photo1) into one row (photo2) using formulas - this the part I do not know how to create. End result I require is to combine this values that are now in one row, into a text (I basically need one comment that is summarizing all the different information which are linked to one same value - in my example, I need to combine all yellow Texts, into one comment related to value "A")
Colors are provided just for clarification.
1.JPG
2.JPG

End result required:
3.JPG

If there are any solution, please advise,
Excel file also is attached, if easier, You can just dump the formula inside that file, and I will figure out the rest,

Thanks in advance,

[zbor]

Use this in S4:

=TEXTJOIN("&",TRUE,FILTER($F$4:$F$29,($E$4:$E$29=R4)))

And extend formula down...

this solution doesn't require helper table (I to P columns).

[wk9128]

Cell J5 formula , Drag down

Please Login or Register  to view this content.

[Bozovicdj]

-zbor
For some reason I do not have "Filter" function, only "FilterXML" and it is not working

-wk9128
The result is either blank, or all the values from column2 (for either of the letter A, B, C, D, E)

[AliGW]

FILTER first appeared in Excel 2021.

[zbor]

The result is either blank, or all the values from column2 (for either of the letter A, B, C, D, E)

Looks OK for me.
Do you use good reference for Value1 criteria?
R10, or in wk9128's I5 is reference to A,B,C...

=TEXTJOIN("&";;IF($E$4:$E$29=$R10;$F$4:$F$29;""))