Formula for Flash Fill Inconsistent Non-Empty Cells

[Eng mona]

I have a very long extended sheet ( the attached is a small copy of it)

I have some NA blank cells in column F. I need to fill these columns with the text join of the details in the cells after it. (till the following empty cells)

The number of non-empty cells after every NA cell in column F is inconsistent.

Can anyone please help adjust a formula to flash-fill the NZ cells for inconsistent non-empty cells?

If I learn how to do this function, I will use it in column D, but this time to have the sum of the non-empty cells. And so on.

Many thanks in advance for any help.

[rory]

You could use:
=IF(F2="N/A",TEXTJOIN(",",TRUE,FILTER(F2:F17,(A2:A17=A2)*(B2:B17=B2)*(F2:F17<>"N/A"))),F2)
assuming you have the relevant functions available in your version.

[Eng mona]

Thank you, Roy.

Tested it, and it worked.