Is there any way in a Excel VB macro where in column A there is data in most cells and, in the cells that are blank the data is in column B to delete the blank column A Cells, which in turn will shift left the data from column B cells – Ending up with all the data in column A and no blank cells. Ready for the VLOOKUP function.
For example:
<tbody>
</tbody>
For example:
before | |
col A | col B |
apples | |
pears | |
oranges | |
bananas | |
grapes | |
mangos | |
strawberries | |
after | |
col A | col B |
apples | |
pears | |
oranges | |
bananas | |
grapes | |
mangos | |
strawberries |
<tbody>
</tbody>