如何在Google表格中合并具有相同ID的行? [英] How to combine rows with same ID in Google Sheets?
本文介绍了如何在Google表格中合并具有相同ID的行?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在尝试合并Google表格中具有相同ID的行
I'm trying to merge rows with same IDs in Google Sheets
发件人:
ID | Category
Augur | A1
Augur | A2
Augur | A3
Augur1 | A1
Augur1 | A2
Augur1 | A3
收件人:
ID | Category
Augur | A1; A2; A3
Augur1 | A1; A2; A3
在Google表格中,是否可以使用其本机功能自动执行此操作?
Is there an automatic way to do it in Google Sheets itself, using its native functions?
推荐答案
=ARRAYFORMULA(QUERY({INDEX(QUERY(A1:B,
"select A,count(A) where A is not null group by A pivot B", 0), , 1),
REGEXREPLACE(TRIM(TRANSPOSE(QUERY(TRANSPOSE(IF(ISNUMBER(QUERY(A1:B,
"select count(A) where A is not null group by A pivot B", 0)), INDEX(QUERY({A1:A,B1:B&";"},
"select count(Col1) where Col1 is not null group by Col1 pivot Col2 offset 1", 0), 1,), ))
, , 999^99))), ";$", )}, "offset 1", 0))
这篇关于如何在Google表格中合并具有相同ID的行?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文