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.

CodePudding user response：

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)), "×")), ",$", ))