Concatenate non empty cells in each row with arrayformula in google sheets-CodePudding

Home > Blockchain > Concatenate non empty cells in each row with arrayformula in google sheets

Concatenate non empty cells in each row with arrayformula in google sheets

Time：08-17

I have a range of values and empty cells A2:F15 I whant to concatinate only non empty cells usign a single formula Arrayformula,

CodePudding user response：

use query smash:

=INDEX(REGEXREPLACE(TRIM(FLATTEN(QUERY(TRANSPOSE(IF(A2:F="",,A2:F&",")),,9^9))), ",$", ))