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.

Groups in Gigasheet

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

Nested Groups

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.

Selecting Column to Group

Similar posts

Thousands of individuals & teams use Gigasheet.

Join Them.
No Code
No Database
No Credit Card
Sign Up Today, Free Forever

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.