I'm getting some really weird results from my QUERY()
Here is an image with an example:
I'm querying for the name where No Show = "No Show". It find the correct name Name 5
but also returns a concatenated list of names separated by a space.
Why is this happening? How do I fix it?