I m finding out VBA for merging text with a space from below cells which has blank at the next column , and then remove the row that has blanks, as shown below.:confused:
First Form
<colgroup><col span="2"><col><col><col><col><col></colgroup><tbody>
1
1.500WT - PIPE SSAWL API 5L BE
30...