SQL - Pivot Column To Rows with Group By and Concat

I need to traspose a column into a row ( by concatenating it) with group by...

using : sql server 2019

Example

How can i get this?

I tried something but i didn't get close enough to show something here.

Need to know your DB name to suggest appropriate answer. It's not pivot rather string aggregation. I will try to cover major RDBMs.

If you are using sql server or postgres you can use string_agg()

Query:

select Car_ID,Car_Name,string_agg(Owner,',') as Owners from Cars
group by Car_ID,Car_Name

Output:

fiddle

If you are using MySql then you can use group_concat():

Query:

select Car_ID,Car_Name,group_concat(Owner) as Owners from Cars
group by Car_ID,Car_Name

Output:

fiddle

If you are using Oracle then you can use listagg() for this purpose:

Query:

select Car_ID,Car_Name,listagg(Owner,',') as Owners from Cars
group by Car_ID,Car_Name

Output:

fiddle