I'm trying to figure out how to "group by" values in an Excel spreadsheet. Given the following example (this is an inventory sheet I use at my restaurant:) At the far right of the spreadsheet ther...

Sep 29, 2009 · To group the items in a Date field Right-click the Date field button. Choose Group and Show Detail | Group In the Grouping dialog box, select one or more options from the 'By' list. To limit …

Mar 3, 2023 · I have some nested grouped rows of a table in different files that I need to move together, but whenever I copy & paste one of the tables, I lose all of my groupings and just get all of the vis...

Jul 6, 2016 · For the group function in Excel, I am able to create groups and levels. However, it seems like if you group a number of rows, and then create a subgroup with the same last element, the …

I'm trying to pull back the members of an AD distribution group using Excel's Power Query tool. Using the Active Directory data source I can query for all users on a domain. Following is the gener...

I have a hierarchical list of items in an Excel worksheet and want to create a macro to group each row based on a cell value that gives the level of indention. The data looks like this: Index Lev...

I have a spreadsheet with about 2000 rows that I need to group together based on the contents of about 12 columns. The key here is that the rows may differ in a number of different columns, but for...

Jun 13, 2019 · I'm trying to find out if there's a shortcut key combination in Excel to expand & collapse an entire group outline level. This would be the the equivalent of mouse clicking on the 1, 2, 3, ...

Jun 15, 2020 · Excel decides I want to join this somehow to the first one. Group columns G:J together This creates a group but combines it with the one done in step 1 Can this behavior be avoided? …

Sep 13, 2022 · I'm struggling to understand how to automatically group identical rows together in Excel. I don't need counts or anything fancy - I just need to bundle all rows that look the same (across …