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 …

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 …

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 …

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 …

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' …

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, …

Jun 2, 2020 · In Excel 365 (version 1908), I want to group columns using the Data -> Outline -> Group function. This works fine, but it only groups columns to the right. However, I want to …

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 …

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...

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 …