Google Sheets professional, anyone?

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.


edit: these are not real data.

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
:smile:

I haven’t used excel in over 10 years…

What does “groupby” do?

1 Like

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.

1 Like

Thanks @jeffeb3 I’will look that. :+1:t3:I have made quite complex things by vlookup. And I tried it for this also without good results :smile:

1 Like

Above one examble :smile:

@jeffeb3 This works great. :slightly_smiling_face:

1 Like