Comments on: Can Google Sheets Group Rows and Columns? Yes, Here’s How

By: jmarkus

jmarkus — Fri, 02 Feb 2024 12:52:34 +0000

In reply to enrico. There's no built-in setting to change the direction of grouping (e.g., from bottom to top). The grouping direction typically follows a top-down approach for rows and a left-to-right approach for columns.

By: jmarkus

jmarkus — Fri, 02 Feb 2024 12:45:47 +0000

In reply to Evan.

If you want to group both the data within each quarter and the quarters themselves, try grouping by two levels. You’ll create an outer loop for each quarter and an inner group for the data in each quarter.

Group Data by Quarter:
Select the rows corresponding to the data for each quarter (Q1, Q2, etc.).
Right-click on the selected rows and choose “Group rows X – Y.”

Group Headers:
Select the cells containing the headers for each quarter (e.g., Q1, Q2, etc.).
Right-click on the selected cells and choose “Group rows X – Y.”
This creates an outer group for the quarters.

When you sort the sheet, the groups will move together, preserving the relationship between quarters and their corresponding data.

By: Christy

Christy — Wed, 05 Jul 2023 05:47:24 +0000

May I know how to change the group function direction?
For example, if I group A to C, how to control the plus icon on Column A or Column C ?

By: Evan

Evan — Fri, 02 Jun 2023 18:10:34 +0000

Is there a way to group the headers of each group as well? When I attempt to group (in your example above) Q1, Q2, etc, into each grouping, it creates a massive single group. I need the headers grouped to sort my sheet. Say I need to redo the sheet and sort by the highest quarters money earned, we dont care about it being in Quarter order. When I sort, the headers all go to the top (highest values) but leave behind all the grouped data at the bottom (still grouped). I now have lost what group belongs to which header. Sorting this information destroys the whole sheet and does not really group the data. Is there a way to fix this?

By: Sujatha

Sujatha — Sat, 20 May 2023 03:11:43 +0000

The details were really helpful.

By: Enrico

Enrico — Thu, 16 Feb 2023 07:18:01 +0000

In reply to enrico.

Ok, i actually solved it 1 minute after…
right click on the + button and hit “move +/- button to the top”
cheers

By: enrico

enrico — Thu, 16 Feb 2023 07:16:32 +0000

How to invert the direction of the grouping? by default (i think?) it group the rows from top to bottom, with the + button being in the bottom row(the opposite of what you show in the guide). Do you know how I can change the direction?
Thanks

By: HHAW

HHAW — Sat, 24 Dec 2022 19:40:52 +0000

This’s exactly what I’m looking for! Thank you so much!

By: Sonia

Sonia — Mon, 15 Feb 2021 15:11:17 +0000

Hello Sumit,

I just wanted to say thanks for your awesome step-by-step guide to group rows and columns in Google Sheets. This really helped me very well!

Best, Sonia

By: Vedonlyöntibonukset

Vedonlyöntibonukset — Fri, 09 Oct 2020 13:08:47 +0000

Thanks for the tip. It was just the thing I was looking for.