The code line that hides the row is
To avoid that the row be hidden, just remove that line.
The code line that clears a a cell content is
It's clearing a cell in the same row, three columns to the right, i.e. if G3 is edited then the content of J3 is cleared. To clear the content of C3 ...
Let me know what you think about this solution. Column D and E can be grouped. Add two extra columns with the formula in my screenshot. Work of the two new columns and update other formulas to reference your new columns.