Textjoin with adjacent headers and rows with a twist

Question

I have a formula that works without taking into account the blank cells when I'm trying to conduct a Textjoin() to obtain the adjacent row header when the cell in a row is filled.

The intended result would be:

example of the desired output:

I have a formula that works without looking at the blanks, what I need is when there is a blank cell the adjacent header is ignored.

Answer 1

Try the following formula-

=TEXTJOIN(" ",1,FILTER($A$1:$C$1,A2:C2<>"")&":"&FILTER(A2:C2,A2:C2<>""))

To make it dynamic (automatically spill results) try-

=BYROW(A2:C4,LAMBDA(x,TEXTJOIN(" ",1,FILTER(A1:C1,x<>"")&":"&FILTER(x,x<>""))))