In your example sheet you have shown the " after" but not the " before" at the same time.

In this sheet, cell references I could see are totally relative instead of partially.

How do you transfer the data? Copy Paste ? Dragging ?

I'm also a bit concerned about the merged cells in col A, they usually mean trouble