I have a document where rows are indented/grouped like this for a column named SCENE/SHOT
And in each of these rows, I also have a column named SETUP with other numbers in it.
My problem is that if I sort according to SETUP, the rows are sorted within the indented groups i.e. those groups stay grouped and therefore the column SETUP is not sorted in an absolute way, but only sorted within each of the indented groups. (see result of the sort on the screenshot)
Is there a way to sort rows according to SETUP in an absolute way (i.e. so that I have SETUP 1, 2, 3, 4, …) thus “bypassing” the indented groups from other columns ??