By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
| id | col1 | col2 | value1 | value2 |
|---|---|---|---|---|
| 1 | A/B/C | Red/Orange/Green | A | Red |
| 1 | A/B/C | Red/Orange/Green | B | Orange |
| 1 | A/B/C | Red/Orange/Green | C | Green |
| 2 | D/E | Red/Orange | D | Red |
| 2 | D/E | Red/Orange | E | Orange |