Copying data from adjacent cell to blank cell (left side)

[raghunaik]

Hi, I get this data from a source which is not captured in order, cell values gets jumped to next adjacent cell. Refer the "AS IS" tab.
I would like to copy the cell values from J (row 2), L(row 5) and P (row 6) to column H. Once cell values copied delete the blank columns. "TO BE" tab shows how it should look once it's completely cleaned up.


I tried to record the macro however it's not of much help, was having a look at "offest" any help here would be really appreciated!! Thanks

 

[raghunaik]

Not sure how to add the sample file here