Not sure if this is what you want for the "corresponding"...
in your example data, col(1)[5]=col(2)[1], col(1)[6]=col(2)[2]... col(1)[ 8]=col(2)[4] ? Maybe I am wrong...
if it is, the script can be something like:
j=1;
for(i=1;i<wks.nrows;i++)
{
if (col(1)[i]== 0/0)
{
col(1)[i]=col(2)[j];
j++;
}
}