Hi!
I'm working in MS Report Builder and trying to create a summary of text values from a column by building them into one string.
In the table example below, I have 3 rows of data with 3 different text values of colors. I want to take all 3 values and put them into row 4 as one string with commas separating them as shown in the example.

I have tried JOIN but not getting anywhere.
TIA, Kevin



