如何在 Google 表格中合并具有相同 ID 的行? [英] How to combine rows with same ID in Google Sheets?

问题描述

我正在尝试合并 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屋！