How to stop merging Excel cells and create tables that are easy to aggregate

When you merge cells to tidy up table headings, sorting stops working. Filters and aggregations also become difficult to ...