Noted about the Merging Cells.

Secondly Yes, my thought was if 4th column is required can copy and paste the formula from left.........