I wish to roll up several rows into just one row based on co and department grouping while concatinating the description and summing the salary.

I’ve used the rollup distinct function but it keeps returning multiple rows as the description is different

Table 1
Co. Salary. Department. Description
78 100. 22. Hello
78. 59. 22. Goodbye

Query result required
Co. Salary. Department. Description
78 159. 22. Hello Goodbye

I tried to run a distinct statement and rollup but it gets confused as it wont comcatinate the text.

Keeps giving multiple rows.