vendredi 7 février 2020

Google Spreadsheet Conditionally Join

I have spreadsheet with two columns.

|---|---------|
| 1 | 2382207 |
| 1 | 2382177 |
| 2 | 2382195 |
| 2 | 2382174 |
| 2 | 2382175 |
| 2 | 2382193 |

I want to join the contents of the second column together, with a | as the separator. I do with using =JOIN("|",B1:B6)

But now what I want is to only include those where the first column = 1. How could I do this conditionally join?

So the outcome that I want is 2382207|2382177

Aucun commentaire:

Enregistrer un commentaire