There's a reason why when you format your data into a table, Excel grays out the Merge And Center option—because it messes around too much with how tables and their filters work.