how to remove null values and move and fill first two rows

how to remove null values and move and fill first two rows of the same COMPOUND_NAME column?????please help me..

  
COMPOUND_NAME   500      300        100        30         10       0.1       0.3     
  
  7977797      73.15965   NULL     43.27641    61.80586    NULL    47.49404    NULL    
  
7977797      84.85707    NULL      40.38514    34.39364    NULL    12.47919    NULL    
  
7977797      NULL        NULL      NULL        NULL       NULL     NULL       NULL       
  
7977797      NULL        NULL      NULL        NULL       20.08656   NULL    -66.87882    
  
7977797      NULL        53.25329    NULL      NULL       NULL       NULL    NULL    
  
7977797      NULL       48.55260     NULL      NULL       18.91425    NULL    48.55655    NULL