SQL how to make GROUP BY grouping without aggregation?

Question

SQL

Hey!
The question is.
lines 7, 8: the values ​​in the first two fields are the same, in the last - different.
The first 2 columns I need to group, but the last one cannot use aggregation. I think the easiest way is comma separated values, I can't figure out how to do it. Maybe there is some function in MS SQL Server 2014?

I want to get the result like this:

Answer 1

stackoverflow.com/questions/451415/simulating-grou...

Answer 2

use GROUP_CONCAT()