How To

Group Data

Gigasheet helps individuals and teams quickly analyze massive, varying data sets without lengthy setup and complicated configuration. Groups allow you to quickly segment rows, or pivot in your data sets.

Grouping organizes rows by a specified categorical column, and collapses rows that meet the specified criteria. Groups provide similar functionality to traditional pivot tables, but are easier to navigate. To the right of each group you'll see a count of the number of rows within the group.

Highlight of Group functionality in Gigasheet UI

You can create nested groups, and rearrange the group hierarchy via the bar at the top of the sheet, or in the Group panel.

Highlight of nested groups in Gigasheet UI

To create a Group, click the group icon at the top and select the column to group. Or, click on the column name and select "Group" from the menu.

Highlight of where Group function can be initiated in Gigasheet UI

Similar posts

100,000+ people use Gigasheet.

Self-service analytics for huge files, databases, warehouses and more.
No Code
No Training
No Install
See it in action

By using this website, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.