Automatically group my account by level and sub level

Copper 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