To shift 5 columns to the upper row, if the upper row is empty

[sneha1889]

I am new to VBA and need a code for the following. I am trying to search a column for empty cells. if it is empty then i want the row below it to move up and occupy the empty space but not the entire row to move up. more like 5 colums around the empty cell to move Is it possible?

I have attached the file as an example. kindly help me.