We’re rewarding the question askers & reputations are being recalculated! Read more.

Hot answers tagged

1

The formula that would give you the desired results would be: =ArrayFormula(REGEXREPLACE(ARRAYFORMULA(TRANSPOSE(TRIM(SPLIT(CONCATENATE(IF(LEN(B3:H8),B3:H8&"★",)&REPT(" "&"♣︎",COLUMN(B3:H3)=COLUMN(H3))),"♣︎")))),"([^★]+).+","$1")) It is a bit convoluted but works fine.


Only top voted, non community-wiki answers of a minimum length are eligible