I am wondering if there is a way to write a macro in Excel to where it searches from say cell A13 to C2000 and merges all cells which are blank with the cells to the left of them.

Any and all help is welcome!

Thanks!