Sort by Parent Values Without Changing Order of Children Rows
I have multiple tasks each with multiple sub-tasks. The tasks and sub-tasks are not in alpha order, for example:
Whether I leave the rows expanded or collapsed, when I sort the rows by task, it sorts the task and the sub-tasks, like so:
However, now the sub-tasks are out of their correct logical order, e.g., analyze data before gather data.
How do I sort based on the value in the parent row (Acme, Beta, Gamma) without that also applying to the children rows? Is the only way to put the sub-tasks in a new column, e.g., to the right of the task? Seems like needless column-proliferation, especially as on my actual sheet I have 2 or even 3 more levels down below the sub-tasks and not all sub-tasks have any or the same number of sub-levels.
Help is greatly appreciated.