By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | category | Answer |
|---|---|---|
| 1 | breakfast | yes |
| 1 | lunch | no |
| 1 | dinner | yes |
| 2 | breakfast | no |
| 2 | lunch | yes |
| 2 | dinner | no |
| ID | breakfast | dinner | lunch | NewCol |
|---|---|---|---|---|
| 1 | yes | yes | no | yes,yes,no |
| 2 | no | no | yes | no,no,yes |