CODEWITHSUNDEEP
google-sheets
jenna_3108
jenna_3108

Reputation: 435

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

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

enter image description here

Upvotes: 0

Views: 49

Answers (2)

player0
player0

Reputation: 1

try:

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

enter image description here

Upvotes: 1

Harun24hr
Harun24hr

Reputation: 36780

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)))))))

enter image description here

Upvotes: 2

Related Questions