Forum Discussion
Grouping Rows
I have a set of data for a collection of shirts. For one shirt in particular, there are multiple ways to get it. I want to create a Group where I can click to expand the additional requirements and c...
JessicaAuvil1 You can highlight rows 16:29 and click Group to have them collapse/expand when you want. Regarding order, using two helper columns, one for Group ID and Item ID can help manage the sorting:
Select Rows
Under Data > Group
Collapse/Expand
That's true but when I sort the items rows 16-29 would stay where they are and the shirt would go elsewhere. Also, I am interested in sorting by different things (name, color, resource, etc.) represented by the different columns so the helper rows wouldn't work in that sense? adversi