Convert multiple rows to single row separated by comma

If your data is changed/formatted to look like this:

Then yes, you can get to this:

Concatenate A:

IF FIRST()==0 THEN MIN([A])
ELSEIF MIN([A]) != LOOKUP(MIN([A]),-1) 
THEN PREVIOUS_VALUE("") + ", " + MIN([A])
ELSE PREVIOUS_VALUE("")
END

Concatenate Q:

IF FIRST()==0 THEN MIN([Q])
ELSEIF MIN([Q]) != LOOKUP(MIN([Q]),-1) 
THEN PREVIOUS_VALUE("") + ", " + MIN([Q])
ELSE PREVIOUS_VALUE("")
END

***MOST PEOPLE MISS THIS NEXT STEP***

Both of the above calculations use Table Calculations with use of LOOKUP() function. To condense down the result(s), requires an additional Table Filter using LAST() function.

Table FIlter:

LAST()=0

Place onto Filters Card...then do the below:

*** EACH OF THE ABOVE REQUIRES A SPECIFIC TABLE CALC SETTING ***

Notice the triangle (Delta) symbol for each? That's your visual indicator that you're using a table calculation. Right-click each on ROWS and from the list of options select Edit Table calculation - again for each one - and set as per below:

I would advise setting the table calculation for the FILTER calc as the last step. Once you've set the calculation in the Filters Card to the above, then right-click it again in the Filters Card, then select EDIT FILTER this time, and select TRUE only. Best way to learn is by doing. Have fun.

Best, Don Wise -

Please don’t forget to upvote and/or Select as Best by clicking the hyperlink below in the response that answered your question.