CONCATENATE ROWS CONTAINING TEXT

[Jaloy_1973]

Hi,

I am trying to transform some data captured from a PDF, in order to work with it.
I have a column with data (Column F), which are identified as ‘Numeric’ Yes/No in column G.
My goal is to concatenate the rows of the non-numeric fields, but the problem is that sometimes I have 2 data to concatenate, others 3, 5...
I was trying to use the multi-row formula, but I don't know how to pick up this variability in the text fields.

I attach a data file with a sample and the target I'm looking for.

Any suggestion?

Many thanks,

Jordi

[binuacs · Accepted solution]

@Jaloy_1973 one way of doing this

[SPetrie · Accepted solution]

Here is another possible way of doing this.

[nagakavyasri · Accepted solution]

Another way of doing this:

[Jaloy_1973]

Many thanks for all your solutions.

Best.