College professor lived in a dumpster for one year

Professor Jeff Wilson might be feeling down in the dumps. He's moved out from the dumpster, yes, the dumpster, he called home for one full year on the campus of Huston-Tillotson University in Austin, Texas.

He's an Environmental Studies professor who he says he wanted to prove you can be happy and healthy in a very small space the way millions of people live around the world. Very small is an understatement try 33 square feet compared with the almost 2,500 square feet of the average American home.

In reality, it was sometimes less than ideal. He did have some amenities though, like a mailbox, air conditioner, and eventually solar power.

Wilson says he wants to be the ultimate one-percenter: Create only oneQ:

How to "collapse" rows?

So, if my current resultset is:
 Set  |  Label  |  Val
------------------------
  A   |  "LabA" |  NULL
  A   |  "LabA" |   1
  A   |  "LabB" |  NULL
  A   |  "LabB" |   2
  B   |  "LabA" |  NULL
  B   |  "LabA" |   3
  B   |  "LabC" |  NULL

What I really want is:
 Set  |  Label  |  Val
------------------------
  A   |  "LabA" |   1
  A   |  "LabB" |   2
  B