Filtering Multiple Data Points in the Same Column

[RobTennis]

Hi,

I have a report that spans many columns (A-AT) and thus becomes too small to print on one page. Some columns contain few characters like names and sport while others columns like Update contain a large amount of data. Currently, I use the filters and like to see all of the data across the different columns. However, in order to print on one page, I have moved/stacked some of the columns (Sport, Name, Coach) under one column and merged the Update/Details across the rows. In doing so, I have now lost my ability to accurately filter the data. Any ideas or help is appreciated.

Thanks,

 

[Fluff]

Any ideas or help is appreciated.

Yup, get rid of the merged cells.
They are best avoided like the plague, because they cause all sorts of problems.