Forum Discussion
Need Help with Tables and Filters
This is unlikely to be of any immediate value to you but Office 365 has (or will soon have) a FILTER function. I have never been attracted to playing 'peek-a-boo' with data for precisely the reason you have found; that is, hiding rows messes up any other content on the sheet.
The FILTER function allows one to select a subset of data from a data table and display it anywhere one chooses without affected the source sheet.
[For those who are confused by the expression 'peek-a-boo', it is an infant game in which people or objects are hidden from a baby to amuse it when they reappear. It is part of cognitive development to realise that hidden objects still exist]
One from Microsoft is still available https://www.microsoft.com/en-us/p/peekaboo/9nblggh0cwlq?source=lp&activetab=pivot:overviewtab
Wow! And I was impressed by your knowledge of Excel.
That pales into insignificance compared to your ability to find this within the Microsoft portfolio!