If I currently have an SQL table that looks like:
| x: string | y: string | z: string |
|---|---|---|
| a | b | c |
| a | b | d |
| a | b | e |
| f | g | h |
| f | g | i |
Is it possible to combine it such that it looks like:
| x | y | z |
|---|---|---|
| a | b | c,d,e |
| f | g | h,i |
I heard it is not possible to store multiple values in a single cell in SQL. However, since z is a string, is there a way to append the strings together?
Thanks!
