SQL合并两行并填充另一行中缺少值的列

I am not able to merge rows and need help in figuring out. Idea is whenever there are multiple rows with same groupid then I would like to merge both rows and fill the empty column with one that has a value. This particularly problematic that I would never know which column will be empty, and there is a possibility that groupid may be same in more than 3 rows(remotely but possible). Here is sample sql dataI am not able to merge rows and need help in fi