Hello,
I have 3 different data sets/tables on the same worksheet that are being dynamically filtered using the FILTER function that allows you to search and filter by ANY field/word. However, once I filter the results then I'd like to have the data sets shift/move up so that there aren't huge gaps between each data set after they've been filtered. Because otherewise you have to scroll down quite a bit until you reach the next filtered data set. For example, using the example file that's attached if I wanted to insert the word "Goods" into the filter, it will filter all 3 data sets but I'm also needing the data sets to condense/move-up so that there aren't huge blank gaps between each data set.
Condensing Filtered Data Sets.xlsx
Bookmarks