Reverse order of data range and exclude the blank cells

[Peptide]

Hello - looking to reverse order of a data range and exclude the blanks. Possible?

Data Range B10:B15
B10=10
B11=20
B12=30
B13=40
B14=blank
B15=blank


Needed Result
C10=40
C11=30
C12=20
C13=10
C14=blank
C15=blank

 

[Scott Huish]

Copy B10:B15 to C10:C15 and sort C10:C15 descending

 

[Peptide]

Thanks for replying - Is there a formula to do this automatically? I am going to use this on about 50 locations on the worksheet.