Joining columns with null marks into one row I used a sub select to get the data I want. I'm struggling to merge it all into one row now though. 

This is an example of the result where its bike but there are loads on them: 

bike    bike    null    null    bike    6       6    
bike    bike    null    null    bike    null    null     
bike    bike    2       2       bike    null    null


Any idea how I can merge or 'join', if you will, these rows together to act as one? 

Output would ideally be bike 2 2 6 6.

The large data output above is literally the output of the query I ran.
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