how can I convert multiple rows into one row
while other values of a column are NULL, easily you can use this query:

SELECT Name,MAX(property_1),MAX(property_2),MAX(property_3)
FROM YourTable
GROUP BY Name