I would like to do similar thing in Google Sheets as I do “groupby” in Excel. I think I could do it by using “query” “textjoin” and “arrayformula” in Google sheets but I don’t know how do I use these together.
Could someone help?
I rarely use google sheets, so I can’t help you, but have you tried asking ChatGPT?
Yes I have. Many times and many ways without good results
I haven’t used excel in over 10 years…
What does “groupby” do?
I populated the lat/lon myself, but I think you might also be able to use FILTER or UNIQUE to get that list. Google sheets and arrays are wild. I haven’t tried them before. I was looking for a solution using LOOKUP, but I didn’t see an easy way to manage that.
Thanks @jeffeb3 I’will look that. 
I have made quite complex things by vlookup. And I tried it for this also without good results
Above one examble
@jeffeb3 This works great. 
