如何获得分组列的不同列表，并使用任何公式在Excel上将它们连接在一列中？

Question

我正在寻找一种只使用Excel公式的方法，以获得列运输的不同列表，其中它按列节分组，然后将列运输模式的结果连接起来。例如，请参阅我的表格。

ID  Student     Section  Transportation Transportation Mode
1   John        A        Walk           Walk + Commute + Car + Bike
2   Mary        A        Walk           Walk + Commute + Car + Bike
3   Amir        A        Commute        Walk + Commute + Car + Bike
4   Joseph      A        Car            Walk + Commute + Car + Bike
5   Kristern    A        Car            Walk + Commute + Car + Bike
6   Rose        A        Car            Walk + Commute + Car + Bike
7   Eric        A        Bike           Walk + Commute + Car + Bike
8   Ching Chong A        Bike           Walk + Commute + Car + Bike
9   Jet         B        Walk           Walk + Car + Bike + Teleport + Motorcycle
10  Mike        B        Car            Walk + Car + Bike + Teleport + Motorcycle
11  James       B        Bike           Walk + Car + Bike + Teleport + Motorcycle
12  Brandon     B        Bike           Walk + Car + Bike + Teleport + Motorcycle
13  Kenneth     B        Bike           Walk + Car + Bike + Teleport + Motorcycle
14  Mark        B        Teleport       Walk + Car + Bike + Teleport + Motorcycle
15  Julie       B        Motorcycle     Walk + Car + Bike + Teleport + Motorcycle
16  Pat         B        Motorcycle     Walk + Car + Bike + Teleport + Motorcycle
17  Vivian      B        Motorcycle     Walk + Car + Bike + Teleport + Motorcycle
18  Trish       C        Fly            Fly + Walk
19  Eli         C        Walk           Fly + Walk

任何帮助都将不胜感激。

Answer 1

如果有动态数组公式，则使用：

=TEXTJOIN(" + ",TRUE,UNIQUE(FILTER($D$2:$D$20,$C$2:$C$20=C2)))

​

​