If you want to place a column range's (say A1:A100's) n-th numerical value into non-sequential cells, put this formula in each desired cell:
{=INDEX(A1:A100,SMALL(IF(ISNUMBER(A1:A100),ROW(A1:A100)-MIN(ROW(A1:A100))+1),n))}

So for example if you want A1:A100's 3rd numerical value to be in cell C4, the formula in C4 would be:

{=INDEX(A1:A100,SMALL(IF(ISNUMBER(A1:A100),ROW(A1:A100)-MIN(ROW(A1:A100))+1),3))}