Google Sheet - How to combine different cells with specific condition into one column-CodePudding

Home > OS > Google Sheet - How to combine different cells with specific condition into one column

Google Sheet - How to combine different cells with specific condition into one column

Time：11-17

How do I combine those highlighted cells in one column? The highlighted cell is based one rule condition that contains a slash.

CodePudding user response：

Try below formula-

=BYROW(B1:INDEX(F:F,INDEX(MAX((IF(B:F<>"",ROW(B:F),0))))),LAMBDA(x,JOIN(", ",FILTER(x,INDEX(ISNUMBER(SEARCH("/",x)))))))

CodePudding user response：

try:

=INDEX(TRIM(FLATTEN(QUERY(TRANSPOSE(IF(REGEXMATCH(B:F; "\/"); B:F; ));;9^9))))