Aggregate strings in rows

[sandy_grewal-16]

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!

[IanT]

Depends on database, take a look at sql function called group_concat.