TEXTJOIN in a Spill Array Formula

[DJunqueira]

Hi all,

I am trying to use TEXTJOIN() in a spill array formula but I kind of notice that it doesn't work very well with spill array, then I came with the formula below:

=CHOOSE(ROW(P3#)-2,TEXTJOIN(" / ",,INDEX(E2#,,1)),TEXTJOIN(" / ",,INDEX(E2#,,2)),TEXTJOIN(" / ",,INDEX(E2#,,3)),TEXTJOIN(" / ",,INDEX(E2#,,4)))

The purpose of this formula is to spill an array for unique values in column A of the worksheet that match values in column B in a single cell. The range L2:M5 has an exemple of what I was looking for and range P2:Q6 is where I applied the formula. My problem is that my solution does not go to more then 4 lines without making it bigger and bigger.

Range E2:H19 and L14:l17 are my testing ground.

I am using Excel 365 in a Win7 then I can't join Office Insider for the new functions like LET().