I'm stuck trying to vlookup multiples values duplicates and return all match into one cell.
I would like to convert with formulas a sheet like this:
| Name | Product |
|---|---|
| James | Peach |
| James | Apple |
| James | Cherry |
| Andy | Banana |
| Wallace | Peach |
| Wallace | Cherry |
| Mike | Banana |
On a new sheet like this:
| Name | Product |
|---|---|
| James | Peach,Apple,Cherry |
| Andy | Banana |
| Wallace | Peach,Cherry |
| Mike | Banana |
