How to concatenate string characters?

43 views Asked by At

I want to concatenate the data in location column into one cell. I don't know if it's possible.

farmtable

Id Item Location
1 Apple Block C
2 Coffee Block A
3 Coffee Block B
4 Apple Block B
Select 
  Item,
  Location
From farmtable
Group By Item

Expected Result

Id Item Location
1 Apple Block C, Block B
2 Coffee Block A, Block B
0

There are 0 answers