REmoving duplicates formula?

Hi guys,

I'm running a formula on a column of data that will result in either a number or a blank in column B. What I want to do is include a fomula that will automatically scan this new column and remove any blanks and put it into column C. Almost like an auto remove duplicates formula that copies to the next column.
Can this be done?
I've included the sheet...