How to compile people mentioned in same row in one column (a 'team' column)

6

Great question here and it’s not necessarily an intuitive formula that can make this work, but @Pch has the right idea. Using ListCombine() and Filter() will make this list possible.

ListCombine([Column 1], [Column 2], [Column 3]).Filter(CurrentValue.IsNotBlank())

I think that should work.

List() can create (One, Two, [Three, Four, Five]) where [Three, Four, Five] is considered 1 item.
ListCombine() flattens it and makes this (One, Two, Three, Four, Five) and is considered 5 items.

2 Likes