Hi Gurus:

I am trying to move contents from a specific cell to another and delete any empty rows produced(see attachment for illustation).
Please write me a code for this task.


Many many thanks,

Chris

Sample Datasheet for Code Request1-Conditioned data shift and empty row elimination.xlsx