Google sheet arrayformula join() 和 split() 函数 [英] Google sheet arrayformula join() and split() functions

问题描述

有谁知道如何数组公式这个join函数?

Does anybody know how to arrayformula this join function?

我的公式不像这里的例子那么复杂.ArrayFormula 联接中的过滤器(Google 电子表格)

My formula is not as complex as the example here. ArrayFormula a Filter in a Join (Google Spreadsheets)

它不包含 filter 函数，所以我不确定该答案中的哪些内容适用和不适用.

It does not contain a filter function, so I'm not sure what from that answer applies and doesn't apply.

我想这样排列公式:=if(isblank(B2),,join("," ,B2:I2))

使用正常的方式来排列东西是行不通的:

Using the normal way to array something doesn't work:

=ArrayFormula(if(isblank(B2:b),,join(",",B2:b:I2:i)))

对于拆分，我还有 split(B2, ",")

=ArrayFormula(split(B2:B,",")) 除了第一行什么都不做

=ArrayFormula(split(B2:B,",")) does nothing but the first row

推荐答案

也许试试:

=ArrayFormula(if(len(B2:B), B2:B&C2:C&D2:D&E2:E&F2:F&G2:G&H2:H&I2:I,))

或

=ArrayFormula(substitute(transpose(query(transpose(B2:I),,rows(B2:B)))," ",""))

或者，如果您想在连接的值之间留一个空格:

or, in case you want a space between the concatenated values:

=ArrayFormula(trim(transpose(query(transpose(B2:I),,rows(B2:B)))))

要在 arrayformula 中使用 split()，可以在此处找到解决方法

For using split() in arrayformula a workaround can be found here

这篇关于Google sheet arrayformula join() 和 split() 函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！