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