1

I want to get the concatenation of the input names according to value like this Name1, Name2,...

I tryed this formula but i need to be dynamic with Arrayformula.
Make a copy of this example

=IF(D3="",,TEXTJOIN(", ",1,FILTER($A$3:$A,$B$3:$B=D3)))

enter image description here

player0
  • 124,011
  • 12
  • 67
  • 124
Osm
  • 2,699
  • 2
  • 4
  • 26
  • [Why should I not upload images of code/data/errors when asking a question?](https://meta.stackoverflow.com/q/285551/3404097) [Why are images of text, code and mathematical expressions discouraged?](https://meta.stackexchange.com/q/320052/266284) – philipxy Sep 03 '22 at 21:33

1 Answers1

1

all you need is:

=ARRAYFORMULA(REGEXREPLACE(TRIM(SPLIT(FLATTEN(QUERY(QUERY(
 FILTER({A3:A&",", B3:B&"×"}, B3:B<>""), 
 "select max(Col1) group by Col1 pivot Col2"),,9^9)), "×")), ",$", ))

enter image description here

player0
  • 124,011
  • 12
  • 67
  • 124