I've come across a challenge with filtering that I'm quite stuck on. Any help would be much appreciated!
I'm working with two drop down menus. Depending on the selection of the first drop down, I would like to sort the second. The problem is that my database is very large (400 rows by 800 columns). I can nail down the appropriate row based on the user selection, but how can I then sort so that only the non-zero column names are shown?
I came across an example code below, but here there are only 4 options (or columns) to consider. How can I apply filtering when I have 800+?
Thanks for any and all help!