Haven't been able to find an answer to this anywhere. I have a table with hidden rows. Each hidden row is associated with the visible row immediately on top of it (matched by column L). When I sort on column B, the hidden/associated rows are sorted too, and they lose their adjacency to the row they're related to (because the hidden rows have different values in column B).
Is there any way to only sort on visible rows, keeping the hidden row association adjacent to its visible counterpart?
Sample file is attached...
Bookmarks