SOLVED

Column Grouping - How to ungroup

%3CLINGO-SUB%20id%3D%22lingo-sub-2323729%22%20slang%3D%22en-US%22%3EColumn%20Grouping%20-%20How%20to%20ungroup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2323729%22%20slang%3D%22en-US%22%3E%3CP%3EI%20recently%20selected%20to%20group%20a%20Sharepoint%20list%20by%20a%20column.%20Now%2C%20I%20cannot%20get%20the%20view%20to%20revert%20back%20to%20an%20ungrouped%20column%20view.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20list%20is%20connected%20to%20Teams%2C%20Power%20BI%2C%20etc.%20In%20all%20places%2C%20the%20view%20is%20grouped%20by%201%20column.%20When%20I%20check%20the%20group%20by%20column%20option%2C%20it%20temporarily%20reverts%20back.%20When%20I%20refresh%2C%20(trying%20to%20edit%20in%20grid%20view)%20it%20reverts%20back%20to%20the%20grouped%20column%20view.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2323729%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2324768%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20Grouping%20-%20How%20to%20ungroup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2324768%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1045106%22%20target%3D%22_blank%22%3E%40kelly_bumpus%3C%2FA%3E%26nbsp%3BFollow%20below%20steps%20to%20solve%20this%3A%3C%2FP%3E%3COL%3E%3CLI%3EGo%20to%20your%20SharePoint%20list.%3C%2FLI%3E%3CLI%3EClick%20on%20%3CSTRONG%3ESettings%3C%2FSTRONG%3E%20(gear%20icon)%20at%20the%20top%20%26amp%3B%20select%20%3CSTRONG%3EList%20settings.%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3EOn%20list%20settings%20page%2C%20scroll%20down%20to%20the%20bottom%20of%20the%20page%20where%20you%20can%20see%20%3CSTRONG%3EViews%3C%2FSTRONG%3E%20section.%3C%2FLI%3E%3CLI%3EClick%20on%20the%20view%20name%20where%20you%20have%20applied%20the%20column%20grouping.%3C%2FLI%3E%3CLI%3EOn%20view%20settings%20page%2C%20scroll%20to%20the%26nbsp%3B%3CSTRONG%3EGroup%20By%26nbsp%3B%3C%2FSTRONG%3Esection%20%26amp%3B%20expand%20it.%3C%2FLI%3E%3CLI%3ESelect%26nbsp%3B%3CSTRONG%3ENone%3C%2FSTRONG%3E%20in%20both%20the%20dropdowns%20(replicate%20the%20settings%20like%20below%20image).%3C%2FLI%3E%3CLI%3EClick%26nbsp%3B%3CSTRONG%3EOK%3C%2FSTRONG%3E%26nbsp%3B%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22ganeshsanap_0-1620191087047.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F278285i062918BCC6A84D38%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ganeshsanap_0-1620191087047.png%22%20alt%3D%22ganeshsanap_0-1620191087047.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EPlease%20click%26nbsp%3B%3CSTRONG%3EMark%20as%20Best%20Response%3C%2FSTRONG%3E%26nbsp%3B%26amp%3B%20%3CSTRONG%3ELike%3C%2FSTRONG%3E%20if%20my%20post%20helped%20you%20to%20solve%20your%20issue.%20This%20will%20help%20others%20to%20find%20the%20correct%20solution%20easily.%20It%20also%20closes%20the%20item.%20If%20the%20post%20was%20useful%20in%20other%20ways%2C%20please%20consider%20giving%20it%20%3CSTRONG%3ELike%3C%2FSTRONG%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2326130%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20Grouping%20-%20How%20to%20ungroup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2326130%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373269%22%20target%3D%22_blank%22%3E%40ganeshsanap%3C%2FA%3E%26nbsp%3B%20Thank%20you!%20This%20worked.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I recently selected to group a Sharepoint list by a column. Now, I cannot get the view to revert back to an ungrouped column view. 

The list is connected to Teams, Power BI, etc. In all places, the view is grouped by 1 column. When I check the group by column option, it temporarily reverts back. When I refresh, (trying to edit in grid view) it reverts back to the grouped column view.

2 Replies
best response confirmed by kelly_bumpus (New Contributor)
Solution

@kelly_bumpus Follow below steps to solve this:

  1. Go to your SharePoint list.
  2. Click on Settings (gear icon) at the top & select List settings.
  3. On list settings page, scroll down to the bottom of the page where you can see Views section.
  4. Click on the view name where you have applied the column grouping.
  5. On view settings page, scroll to the Group By section & expand it.
  6. Select None in both the dropdowns (replicate the settings like below image).
  7. Click OK 

ganeshsanap_0-1620191087047.png


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

@ganeshsanap  Thank you! This worked.