Hello!
I was hoping there was a way to build a table calculation(s) to aggregate rows into a single row. Example of how my data looks:
ID | Fruit |
---|---|
1111 | Apple |
1111 | Orange |
2222 | Grapes |
2222 | Apple |
2222 | Banana |
3333 | Grapes |
3333 | Apple |
3333 | Pine Apple |
3333 | Orange |
And I want the output to look like:
ID | Fruit |
---|---|
1111 | Apple, Orange |
2222 | Grapes, Apple, Banana |
3333 | Grapes, Apple, Pine Apple, Orange |
If someone can kindly lead me in the right direction on how to do this, I would really appreciate it!
Depends on database, take a look at sql function called group_concat.