汇总数据帧，以沿着子集返回非na值

Hoping that someone can help me with a trick. I've found similar questions online, but none of the examples I've seen do exactly what I'm looking for or work on my data structure. Hoping that someone can help me with a trick. I