0

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"

=sort(unique(filter(A2:A,C2:C<>"Hold")),1,1)

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))

Start Table

End Result

file of reference Google Sheet

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.