merge rows?!

I have quotes that pass through s1 and s9 (s9 means the quote was cancelled because its a duplicate) 

the rows "count of s1" and "count of s9" are measures.

I want to remove any quotes that had a count of s9. thats easily done by subtracting s1 from s9 which will give me 0. My problem comes when i introduce another column (Name) which comes from a different table called the user table. To explain the issue i will give an example: 

 On the left table below, quote 77850 shows up once and shows me that it had a count of s9 (duplicate quote), which i would then want to remove that quote. but when i introduce the name column (as seen in the image on the right), quote 77850 is seen twice, one row with count of s1 and the name of associated with it, and another that shows me the quote id "77850" and that it did go through s9 but doesnt show me the "name" nor the fact that it passed through "count of s1" 

How can i make it so i can merge the rows, where quote 77850 would show up once when i introduce the "name" column, where the row would include count of s1=1 , count of s9=1 and name=Not null? 

is that possible?