i am wanting to combine multiple rows into a single column as a string value
my data is as such...
description | title | body
aaa one 1
aaa two 2
aaa three 3
bbb four 4
bbb five 5
ccc six 6
i want to have a sinlge string output in the format
aaa + one + 1 + two + 2 + three + 3 + bbb + four + 4 + five + 5 + ccc + six + 6
in other words concat description title and body together for all rows but group by description...
i understand PIVOT is the best approach but havent been able to get the output i need
can anyone help ?