Ideas welcome - formatting trial balance

smurad008

I am generating a trial balance that is ultimately going to look like this : 

My current trial balance looks like this.

1. I can't seem to figure it out with data cleansing but I need to remove leading spaces so I can separate the number from the Name. 
2. Second I need to somehow eliminate the total column so I can only get the individual account that makes up the total. 
3. When I tried [TB Accounts] = "checking:" or [TB Accounts]="Account Name" - I thought it was too much, maybe a faster way to do it? If the total name changes?

Can any of you help me with this? I attached a sample file. I appreciate any help. 

Example.xlsx

fmvizcaino

Hi @smurad008 ,

Attached is an example showing how to do it.

Let me know if you need further assistance.

Best,

Fernando Vizcaino

2020-03-17 Ideas welcome - formatting trial balance.yxmd