Grouping Rows

%3CLINGO-SUB%20id%3D%22lingo-sub-2152055%22%20slang%3D%22en-US%22%3EGrouping%20Rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2152055%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20set%20of%20data%20for%20a%20collection%20of%20shirts.%20For%20one%20shirt%20in%20particular%2C%20there%20are%20multiple%20ways%20to%20get%20it.%20I%20want%20to%20create%20a%20Group%20where%20I%20can%20click%20to%20expand%20the%20additional%20requirements%20and%20click%20again%20to%20hide%20them%20while%20having%20the%20row%20with%20the%20name%20of%20the%20shirt%20(row%2015)%20visible.%20However%2C%20I'm%20planning%20on%20having%20the%20columns%20be%20filtered%20(sort%20alphabetically%2C%20by%20completion%2C%20etc.)%20and%20I%20want%20the%20grouped%20rows%20to%20move%20together.%20Is%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2152055%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2152424%22%20slang%3D%22en-US%22%3ERe%3A%20Grouping%20Rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2152424%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F973172%22%20target%3D%22_blank%22%3E%40JessicaAuvil1%3C%2FA%3E%26nbsp%3BYou%20can%20highlight%20rows%2016%3A29%20and%20click%20Group%20to%20have%20them%20collapse%2Fexpand%20when%20you%20want.%20Regarding%20order%2C%20using%20two%20helper%20columns%2C%20one%20for%20Group%20ID%20and%20Item%20ID%20can%20help%20manage%20the%20sorting%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22adversi_0-1613855686350.png%22%20style%3D%22width%3A%20207px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256349i30D4C4C86F264806%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22adversi_0-1613855686350.png%22%20alt%3D%22adversi_0-1613855686350.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESelect%20Rows%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22adversi_0-1613855475392.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256346i01EC12B088EAD495%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22adversi_0-1613855475392.png%22%20alt%3D%22adversi_0-1613855475392.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnder%20Data%20%26gt%3B%20Group%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22adversi_1-1613855500668.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256347iDD2281352A7D75AC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22adversi_1-1613855500668.png%22%20alt%3D%22adversi_1-1613855500668.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECollapse%2FExpand%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22adversi_2-1613855539132.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F256348iF02CDFFCF6A903A7%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22adversi_2-1613855539132.png%22%20alt%3D%22adversi_2-1613855539132.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2160197%22%20slang%3D%22en-US%22%3ERe%3A%20Grouping%20Rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2160197%22%20slang%3D%22en-US%22%3E%3CP%3EThat's%20true%20but%20when%20I%20sort%20the%20items%20rows%2016-29%20would%20stay%20where%20they%20are%20and%20the%20shirt%20would%20go%20elsewhere.%20Also%2C%20I%20am%20interested%20in%20sorting%20by%20different%20things%20(name%2C%20color%2C%20resource%2C%20etc.)%20represented%20by%20the%20different%20columns%20so%20the%20helper%20rows%20wouldn't%20work%20in%20that%20sense%3F%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F867265%22%20target%3D%22_blank%22%3E%40adversi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2160601%22%20slang%3D%22en-US%22%3ERe%3A%20Grouping%20Rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2160601%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F973172%22%20target%3D%22_blank%22%3E%40JessicaAuvil1%3C%2FA%3E%26nbsp%3BThe%20best%20way%20is%20to%20continue%20adding%20more%20data%20to%20your%20table.%20At%20the%20moment%20it%20only%20contains%20two%20columns%20(Shirt%2C%20Fossil).%20Adding%20more%20columns%20(Name%2C%20Color%2C%20Resource%2C%20etc.)%20will%20provide%20a%20more%20fledged-out%20table%20to%20work%20with.%20From%20there%2C%20creating%20an%20ID%20system%20based%20on%20these%20other%20columns%20can%20help%20track%2C%20order%20and%20manage%20all%20your%20rows%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 click again to hide them while having the row with the name of the shirt (row 15) visible. However, I'm planning on having the columns be filtered (sort alphabetically, by completion, etc.) and I want the grouped rows to move together. Is this possible?

3 Replies

@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:

adversi_0-1613855686350.png

 

 

Select Rows

adversi_0-1613855475392.png

 

Under Data > Group

adversi_1-1613855500668.png

 

Collapse/Expand

adversi_2-1613855539132.png

 

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 

@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