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?