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 nonempty cells after every NA cell in column F is inconsistent.
Can anyone please help adjust a formula to flashfill the NZ cells for inconsistent nonempty 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 nonempty cells. And so on.
Many thanks in advance for any help.
Formula for Flash Fill Inconsistent NonEmpty Cells

 Lounger
 Posts: 41
 Joined: 13 Feb 2024, 09:41
Formula for Flash Fill Inconsistent NonEmpty Cells
You do not have the required permissions to view the files attached to this post.

 5StarLounger
 Posts: 823
 Joined: 24 Jan 2010, 15:56
Re: Formula for Flash Fill Inconsistent NonEmpty Cells
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.
=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.
Regards,
Rory
Rory

 Lounger
 Posts: 41
 Joined: 13 Feb 2024, 09:41
Re: Formula for Flash Fill Inconsistent NonEmpty Cells
Thank you, Roy.
Tested it, and it worked.
Tested it, and it worked.