问题描述
有谁知道如何数组公式这个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() 函数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!