grouping activities and sub activities

%3CLINGO-SUB%20id%3D%22lingo-sub-1607207%22%20slang%3D%22en-US%22%3Egrouping%20activities%20and%20sub%20activities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1607207%22%20slang%3D%22en-US%22%3E%3CP%3EHoping%20someone%20can%20help%20me%20out%20with%20some%20tips%20or%20tricks.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20basic%20XLS%20that%20has%207%20columns.%26nbsp%3B%20The%20first%20column%20lists%20the%20primary%20location%20(10%20in%20total).%26nbsp%3B%20Each%20location%20then%20has%20a%20second%20column%20listing%20the%20Action%20associated%20with%20that%20location%20(6%20for%20each%20location).%26nbsp%3B%20The%203rd%20column%20lists%20the%20steps%20for%20each%20Action%20(6%20for%20each%20Action).%20The%20remaining%20columns%20are%20filled%20with%20%25%20complete%2C%20start%20and%20finish%20dates%20etc.%20but%20I'm%20confident%20that%20I%20have%20that%20no%20issue.%26nbsp%3B%20My%20question%20is%20that%20I%20want%20to%20group%20each%20of%20the%20activities%2C%20by%20location%20and%20then%20Action%20and%20then%20Steps%20(with%20subtotal%20in%20each).%20rolling%20it%20up%20into%20a%20major%20subheading%20total%20for%20each%20location.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%20something%20like%20this%3A%3C%2FP%3E%3CP%3ELocation%20X%20-%20action%201%20through%206%20(listed%20vertically)%20with%20steps%20for%20each%20action.%20Sub%20total%20for%20each%20and%20a%20grand%20total%20for%20each%20location.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1607207%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1607382%22%20slang%3D%22en-US%22%3ERe%3A%20grouping%20activities%20and%20sub%20activities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1607382%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F768613%22%20target%3D%22_blank%22%3E%40JMH1671%3C%2FA%3E%26nbsp%3BSounds%20like%20you%20need%20a%20Pivot%20Table.%20More%20about%20that%20in%20teh%20attached%20link.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hoping someone can help me out with some tips or tricks.  

I have a basic XLS that has 7 columns.  The first column lists the primary location (10 in total).  Each location then has a second column listing the Action associated with that location (6 for each location).  The 3rd column lists the steps for each Action (6 for each Action). The remaining columns are filled with % complete, start and finish dates etc. but I'm confident that I have that no issue.  My question is that I want to group each of the activities, by location and then Action and then Steps (with subtotal in each). rolling it up into a major subheading total for each location.

 

Basically something like this:

Location X - action 1 through 6 (listed vertically) with steps for each action. Sub total for each and a grand total for each location. 

1 Reply

@JMH1671 Sounds like you need a Pivot Table. More about that in teh attached link.

 

https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bf...