Joining columns with null marks into one row
It's difficult without seeing your query, but you want to aggregate on your fields with null values if you want to remove the redundant rows.

This query would give you one row of data in this example, I'm not sure how you mean to get your output where you are removing two rows.

SELECT
     Field1
    ,Field2
    ,MAX(Field3) Field3
    ,MAX(Field4) Field4
    ,Field5
    ,MAX(Field6) Field6
    ,MAX(Field7) Field7
FROM TableName
GROUP BY
     Field1
    ,Field2
    ,Field5