By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| Group_ | Apples | Oranges | Bananas | Grapes |
|---|---|---|---|---|
| 1 | 1 | 1 | 0 | 0 |
| 2 | 0 | 0 | 0 | 1 |
| 3 | 1 | 1 | 1 | 0 |
| Group_ | output |
|---|---|
| 1 | Apples,Oranges |
| 2 | Grapes |
| 3 | Apples,Oranges,Bananas |
| Group_ | Apples | Oranges | Bananas | Grapes |
|---|---|---|---|---|
| 1 | 1 | 1 | 0 | 0 |
| 2 | 0 | 0 | 0 | 1 |
| 3 | 1 | 1 | 1 | 0 |
| Group_ | output |
|---|---|
| 1 | Apples,Oranges |
| 2 | Grapes |
| 3 | Apples,Oranges,Bananas |