vlookup perhaps?, array formula

Hi all,

I am looking for an ‘array-type’ formula (…I think) that will search a range of cells and grab the first value and copy it to the first cell, then continue on and look for the next cell in the range with a value, then copy that value into the next cell etc…sorry, kind of complicated, but I’m not sure how to explain it any better. I have attached a spreadsheet for clarification (See columns R and S)

Thanks in advance -