I’ve found similar questions, but none with this type of condition. I need to join all cells that are dependent of another cell, separating it by comma. So, If A2:A has repeated values, concatenate all the correspondennt B2:B, the dependent cells from the A2:A.
Given the sheet:
| Column A | Column B |
|---|---|
| Jhon | One |
| Jhon | Two |
| Marcos | Zero |
| Monica | Two |
I need to output:
| Column C | Column D |
|---|---|
| Jhon | One, Two |
| Marcos | Zero |
| Monica | Two |
The cells aren’t predicted values, so I can’t declare "One", or "Two" as a condition in neither C or D collumns.
I tried to modificate this formula: =ARRAYFORMULA(JOIN(", ",FILTER(B3:P3,NOT(B3:P3="")))) as =ARRAYFORMULA((SE(A2:A=A2:A,B2:B & B2:B)), but it outputs an error.
>Solution :
You may try:
=byrow(unique(A1:A4),lambda(z,{z,join(", ",filter(B:B,A:A=z))}))
