Merge and Center Filtering

[cloyd1980]

I have a question that I'm not sure is even possible. Let's say I am creating a spreadsheet that has budgeting info... Budget owner, vendor paid, date, etc and then at the far right of the spreadsheet I need to list each invoice number and invoice amount (typically 5+ invoices per vendor). This report needs to be presentable to senior leadership, and because of that, I am trying to merge and center the vendor name, budget owner, etc across as many rows as there are invoices. So in essence, you see one large row (maybe 5 rows high) that says Vendor ABC, owner John Smith and then when you scroll to the right you see 5 different invoice numbers each with their own cell. While this looks great and is easy to read, the problem I'm having is that if I try to filter on a budget owner or a vendor it only filters on the invoice that is in the same row as the name that I merged and centered across all 5 rows. Is there a way to do this so when I filter it displays the full merged and centered row with all the invoice numbers contained in that area? Hopefully this made sense.

Thanks for the help,
Corey

 

[bobsan42]

Create a new column which contains the vendor name on every row then use it for filtering. It doesn't have to be visible - if you data is in a table object you can add a slicer to use for filtering.