Forum Discussion
Grouping Rows
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
- JessicaAuvil1Feb 23, 2021Copper Contributor
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
- adversiFeb 23, 2021Iron Contributor
JessicaAuvil1 The best way is to continue adding more data to your table. At the moment it only contains two columns (Shirt, Fossil). Adding more columns (Name, Color, Resource, etc.) will provide a more fledged-out table to work with. From there, creating an ID system based on these other columns can help track, order and manage all your rows