Automatically group my account by level and sub level

%3CLINGO-SUB%20id%3D%22lingo-sub-2788141%22%20slang%3D%22en-US%22%3EAutomatically%20group%20my%20account%20by%20level%20and%20sub%20level%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2788141%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20Microsoft%26nbsp%3B365.%20I%20want%20to%20automate%20a%20no-brainer%20task.%20My%20research%20on%20Youtube%20doesn%E2%80%99t%20give%20me%20the%20answer.%3CBR%20%2F%3E%3CBR%20%2F%3EOur%20accounting%20system%20generates%20a%20Charte%20of%20accounts%20with%20the%20symbol%20%E2%80%9C%7C%E2%80%9D.%20Each%20%E2%80%9C%7C%E2%80%9D%20represents%20a%20level%20of%20account%20and%20sub%20account.%20A%26nbsp%3Blevel%20can%20have%20another%20level%20embedded%20and%20child.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CSTRONG%3EI%E2%80%99m%20looking%20to%20automatically%20group%20my%20account%20by%20level%20same%20has%20shown%20below%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image001.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F313083iF8500B8EC534EF09%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image001.png%22%20alt%3D%22image001.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2788141%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2804732%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20group%20my%20account%20by%20level%20and%20sub%20level%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2804732%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1167641%22%20target%3D%22_blank%22%3E%40Pier-OlivierTC%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Elook%20into%20grouping%20rows%20in%20excel%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Yea_So_0-1633136892326.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F314519iD887A686A1C1F153%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Yea_So_0-1633136892326.png%22%20alt%3D%22Yea_So_0-1633136892326.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I'm using Microsoft 365. I want to automate a no-brainer task. My research on Youtube doesn’t give me the answer.

Our accounting system generates a Charte of accounts with the symbol “|”. Each “|” represents a level of account and sub account. A level can have another level embedded and child.


I’m looking to automatically group my account by level same has shown below

image001.png

1 Reply

@Pier-OlivierTC 

 

look into grouping rows in excel:

Yea_So_0-1633136892326.png