By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
| id | activity |
|---|---|
| 12345678 | {"Date (05/19/2020)": null, "Date (06/03/2020)": "06/01/2020", "Type (05/19/2020)": null, "Type (06/03/2020)": "E"} |
| 98765432 | {"Date (05/19/2020)": "05/18/2020", "Date (10/23/2020)": "10/26/2020", "Type (05/19/2020)": "B", "Type (10/23/2020)": "T"} |
| id | activity_date | date | type |
|---|---|---|---|
| 12345678 | 05/19/2020 | null | null |
| 12345678 | 06/03/2020 | 06/01/2020 | E |
| 98765432 | 05/19/2020 | 05/18/2020 | B |
| 98765432 | 10/23/2020 | 10/26/2020 | T |