Forum Discussion
vipett
Helper III
Helper IIICombine two columns and multiply occurrences
I have a column called date in one table :
2021-01-01
2021-01-02
2021-01-03
2021-01-04
etc
And another column called Items in another table
Item A
Item B
Item C
Item D
etc
I would like to create a new table with looks like this
| Date | Item |
| 2021-01-01 | A |
| 2021-01-01 | B |
| 2021-01-01 | C |
| 2021-01-01 | D |
| 2021-01-02 | A |
| 2021-01-02 | B |
| 2021-01-02 | C |
| 2021-01-02 | D |
| etc |
What's the best way of doing this?
