Creating a dstring with a row of values in a query (not concatenate)

[Nanuaraq]

I have a table with case numbers:





I also have a table with specific properties that a case may have:


Each case may have either none, a single, or more than one, of these Y-propeties.
To manage these values, I create a third table with the properties of each case:



Now I wish to query the cases and their properties. In a query, the values may be returned like this:




However, for reasons of quick overview and convenience in other tasks, I would like the values to be returned like this:




Is this possible to do in a query? How?

Hoping someone may help me here. Thank you in advance.

[June7]

With VBA concatenating Property values into a string. Concatenating is the only way to get that CSV output. http://allenbrowne.com/func-concat.html