How to replace values / copy down values in a column when the values are different every few column?

I couldn't use a simple replace value function for above, as the 'value' is different after some number of columns. I could manually use the 'fill' then 'down' function in Excel, just wondering...