I'm stuck on trying to solve this google spreadsheet issue. I have an table with for example countries and then details. What I would like to do is create a table automatically that concatenates all the details per country into 1 line with a separation (", " or "< br >"). I have pasted below a pictures of the example starting table and then the output table. For the countries I use a simple unique formula in this case I added a formula to exclude the status "Hold"
the problem is with the next two columns I am able to generate 1 part automatically but then I am still forced to drag that formula down which defeats the purpose of have it dynamically changing.
what I used: =ArrayFormula(substitute(concatenate(", "&FILTER(B2:B,A2:A=G1)),", ","",1))
file of reference Google Sheet