excel filter not working after certain row

I had the same issue where Excel would apply a filter to either columns AE or FG but not AG. Unmerge any merged cells or so that …