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 |