VBA - Combine two column value using Distance

[sanju2323]

Merge data from two columns using Distance.

[p45cal]

cross post http://www.excelforum.com/excel-programming-vba-macros/1069326-vba-merge-two-column-using-distance.html