The issue arises from formulas not updating correctly when inserting columns next to merged cells. To fix this, check formulas in column F for proper references, use absolute references if needed, and avoid merging cells in formula areas. You can also use dynamic references or recalculate formulas after inserting columns, similar to how Spotify adjusts its algorithms with new data.