By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| ID | col3 | col4 | col5 | col1_X | col1_Y | col2_G | col2_Q |
|---|---|---|---|---|---|---|---|
| 1 | CA | DA | EA | Y | N | Y | N |
| 1 | RA | DA | EA | N | Y | Y | N |
| 2 | CA | DA | EA | N | Y | Y | N |
| 2 | CA | DA | EA | Y | N | Y | N |
| 3 | CA | DA | EA | N | Y | N | Y |
| 3 | CA | DA | EA | Y | N | N | Y |