For a study, I downloaded a LibreOffice Calc document, but when sorting the columns, column (B) with place names remains static.
It does not move when I sort a column, and that is precisely the point: it needs to move so that I can get the overview I want.
I’ve been working on this for about an hour and a half now, but it seems that this auto filter is nested.
I see that it is merged into columns D to J.
Below that are a number of subcolumns, and below those are several columns with an auto filter.
AARGGG… I’m pulling my hair out.
Can someone explain to me how to do this?
The point is that column B has to move along with the filtering of the results.
Can someone explain to me in a step-by-step plan how to do that?
I hope I have explained the question well enough
I have included the LibreOffice Calc file
bevoelkerung_religionszugehoerigkeit_je_gemeinde.xlsx (820.1 KB)