Dynamic Multi Row Formula

[sebenciven]

Good morning,

I would like to find a way to be able to calculate the key field. This must be composed by the concatenation of the fields that have FLAG = 'C'. The computed key will have to be the same for all rows and change when a new set of rows with FLAG = 'C' reoccurs. In the first image the data set, in the second image the result I would like to obtain. The fields with FLAG= 'C' may vary in numerosity.

Thanks to everyone!

[binuacs]

@sebenciven