When one of the values is empty while using the Paste Links function, the value in the transposed data for that particular cell would come out as 0.