Excel Text Join: Extract Cell Values From Duplicated Column Values

Question

I have the following scenario:

I have repeated values in Column C and Column D. I have some values in column E.

Problem

Output required: I have the unique values of column C in the Column K and unique values of column D distributed in Row 4 (L4:R4).

I want to join texts from Column E if the values in Column C and Column D matches. I want the following.

Output Required

How to do this in excel using functions (no VBA)? Thanks.

Answer 1

In L5:

=TEXTJOIN(CHAR(10),,FILTER($D$5:$D$19,($B$5:$B$19=$K5)*($C$5:$C$19=L$4),""))

and copied right and down.

You'll need to Wrap Text in these cells and set the Row Height appropriately in order to see your desired linebreak delimitation.