Flatten a table
Flatten a table
Is it possible to flatten a table that I'm creating by an SQL query from another table?
For example, I have this table:
1
A
C
D
2
B
C
E
F
3
C
D
E
I would like to turn it into this table:
1
A
C
1
A
D
2
B
C
2
B
E
2
B
F
3
C
D
3
C
E