Issues with Groups not Grouping Identical Content

[Peter_Kassel]

Hello! I have been organizing the content of my company’s information for a few weeks and got to the point where I could set up a customer table from my list. When I choose what information is going to be present, and then group the information, even though the essential groupings are identical, Airtable is breaking the information up. You can see the attached screenshot (with names redacted) for an example.

Customer Relationship and Market Sector are the items that I am grouping by and this is what happens:

Is there some sort of metadata that could be causing this issue?

[Kamille_Parks]

Try
ARRAYCOMPACT(ARRAYUNIQUE(values))
or
ARRAYUNIQUE(ARRAYCOMPACT(values))

[Peter_Kassel]

The first formula having been applied to both Market Sector and Relationship has worked! Thank you very much!

[Kamille_Parks]

Great! For reference, ARRAYCOMPACT() removes white space or “empty” values returned in a Rollup.